AD 79-10-14 R1
Registered aircraft · 56,582
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N50941Labrucherie Peter E · El Centro, CAN50944Munoz Jacqueline T · Huntsville, ALN50947Bend Aircraft Mechanics LLC · Bend, ORN50948Salomonsson Mats E · Hayward, CAN5094RHigh View Air LLC · Driftwood, TXN50957Anklam Eugene E · Claremore, OKN50958Stangel Richard C · Enterprise, ORN5095DTevik Michael A · Provo, UTN5095ESchroeder Michael L · Ayr, NDN5095RTraining Planes LLC · Tampa, FLN50960Ortiz Tech LLC · Doral, FLN50961Flight Skills LLC · Raleigh, NCN50967Sellers Raymond L · Trussville, ALN50968Pacific Fleet Aviation LLC · Rochester, NYN5096CMetro Aircraft Co · Bloomington, MNN5096GRiya Aviation LLC · Tracy, CAN5096HMyhre Norman G · Hixton, WIN50975N50975 LLC · Raleigh, NCN50976Cape Aviation Services LLC · Hyannis, MAN5097EBenedikt Craig A · Clayton, GAN5097NDevericks Richard · Ventura, CAN5097RPlymouth Flying Club Inc · Plymouth, NCN5097VCamm Air · Spencer, IAN50984Roberts Wayne A Jr · Juneau, AKN50987Berg James O · Dunseith, NDN50988Propability One LLC · Daytona Beach, FLN50989Und Aerospace Foundation · Grand Forks, NDN5098DShepard Mark S · Malin, ORN5098NReed Kenneth C · Hollywood, MDN5098RWilliams Austin T · Sheridan, INN5098VHarvestowne Aviation LLC · Saint Charles, MON50990Fielden Virgil A · Fairfield, TXN50992Flom Tyler M · Evans, GAN50994Plane Junkies LLC · Dover, DEN50996Burke John E · Spring, TXN5099KSaari Michael · Sycamore, ILN5099NRabinowitz Jeffrey Evan · Akron, OHN5099RFly High Aircraft Sales LLC · Ocilla, GAN5099VNew Horizon Aviation Inc · Warwick, RIN509ARRegistered aircraftN509ATPollard Weldon Luke · Ardmore, OKN509BWAnderson Richard D Jr · Remus, MIN509EREmbry-Riddle Aeronautical University Inc · Prescott, AZN509FGMustang Sally Aviation LLC · Camden, SCN509NDPhoenix East Aviation LLC · Daytona Beach, FLN509PGLake Stories LLC · Crosslake, MNN509SMCompton Stephen · Kennewick, WAN509SPScandinavian Aviation Academy Inc · El Cajon, CAN509TAN509ta-Ln LLC · New Braunfels, TXN50AUDapp Eric M · Corvallis, OR
Back to AD 79-10-14 R1