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.
N564MCB Air Lc · Sikeston, MON564MML A M Capital Management LLC · Sheridan, WYN564PCHargest Custom Cabinetry LLC · Clermont, NJN564QLSimcic Kathryn C · Grain Valley, MON5650BPlane Life LLC · Wilmington, DEN5650CMorris Kenneth E · Poplar Grove, ILN5650TWander Harry J · Nevada City, CAN56511Wired Flight LLC · Kent, WAN5651RChickasha Wings Inc · Chickasha, OKN5651TRegistered aircraftN5652APatriot Aviation · Loomis, CAN5652ECgumps LLC · Antioch, TNN5653BKey Jon · Seminole, TXFirst renewal noticeN5653GCavanaugh Joseph Rex · Alvin, TXN5654CGelardo Matthew L · Cardiff By The Sea, CAN5654GNorman Charles E · Zanesville, OHN5654RSudbrink Charles D · Willet, NYN5654THayes Travis · Harrisonville, MON5655GAnderson Kevin G · Pleasant Hill, CAN5656CScully Michael J · San Carlos, CAN5656EN2893e LLC · Reno, NVN5656GLet There Be Flight LLC · Portage, MIN5657ENobis Chase · Lyons, MIN5657RFord Darryl · Caldwell, IDN56581United States Department Of Interior · Boise, IDN5658AEwartsville Flyers LLC · Pullman, WAN5658BSheyman Igor · Danville, CAN5658REilers Scott D · Amissville, VAN5659AChaouki Rebecca · La Crosse, WIN5659BAom Aircraft LLC · Wilmington, DEN5659EBrewer Randall K · Bloomington, INN5659GLacy Melodi J · Swanton, VTN5659JGilbert Duane A · Reno, NVN5659TMorgan Peter Thomas · Bellingham, WAN565ADPhoenix East Aviation LLC · Daytona Beach, FLN565CHTextron Aviation Employees Flying Club Inc · Wichita, KSN565CMBackcountry Aviation LLC · North Salt Lake, UTN565EREmbry-Riddle Aeronautical University Inc · Prescott, AZN565KGGilley Jerry · Maryville, TNN565MCAviator Air Flight School LLC · Grand Prairie, TXN565NDAerosim Academy Inc · Sanford, FLN565RAN565ra LLC · Elbert, CON565SATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN565SMMuller Scott B · Verbank, NYN565SPLlp Leasing Group LLC · Lewes, DEN565UEsposito John A · Rye, NHN5660BHarlow Brett · Pryor, OKN5660GLawrence Corey R · Bourbon, MON5660RSpirit Hills Ranch LLC · Belgrade, MTN5660TChoose You LLC · Twin Falls, ID
Back to AD 79-10-14 R1