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.
N53103Top Flight Aerial Photography LLC · Georgetown, TXN53105Pence Dale E · Garnett, KSN53107Pea-Wayman Flight LLC · Daytona Beach, FLN53108Prindle Steven G · Seaford, DEN5310DD & S Aviation LLC · Spring, TXN5310ENeiman Enviroments Inc · Junction, TXN53116Wnc Aviation LLC · Arden, NCN5311CBudde Bobby M Jr · San Jose, CAN5311HBas Part Sales LLC · Greeley, CON5312CLemanski Joseph S · Grosse Ile, MIN5312HSkywarrior Flight Training Inc · Pensacola, FLN5312KDelta State University · Cleveland, MSN5312SGace Flying Club · Ronkonkoma, NYN5312VBounds Justin M · Houston, TXN53134Sundog Logistics LLC · Lenexa, KSN5313CSlater John · Saint Charles, ILN5313NGavin Patrick H · Carlsbad, CAN5313TDingman James B · Spencerville, INN5313USky Quest 210 LLC · Clarksdale, MSN53143Delta State University · Cleveland, MSN53147Cloud Cappers Flying Club Inc · Salisbury, NCN5314E57d Flyers LLC · Shelby Township, MIN5314KLaporte Aviation Services Inc · La Porte, INN5314QN5314q LLC · Titusville, FLN5314RDelta State University · Cleveland, MSN5314TWynot Aviation LLC · Riverton, WYN5314VBurke Sterling M · Olympia Fields, ILN5314XMoody Bible Institute Of Chicago · Spokane, WAN53152Griffin Bruce H · Trenton, FLN53158Schoen William R · Madison, CTN5315BBrady Brian O · Kirkland, WAN5315EEastern Cincinnati Aviation Inc · Batavia, OHN5315QLessig Bruce D · Casper, WYN5315SDejean Karl J · Colorado Springs, CON5315TLocal Flight Adventures LLC · Morgantown, WVN5315XAtarah LLC · Tucson, AZN53160Benson Michael H · New Castle, PAN5316DErickson Todd E · Wasilla, AKN5316GBerg Philip L · Chatsworth, CAN5316RTraining Planes LLC · Tampa, FLN5316THavre Flying Club Inc · Havre, MTN53170Price Brian · Page, AZN53175Kendall Investment Corp · Three Lakes, WIFirst renewal noticeN53176Perfect Agreements Leasing Inc · Trabuco Canyon, CAN5317ABlue Skies Air LLC · Allen, TXN5317BWilson Bach M · Piedmont, SCN5317CLiverett Herb · Rio Linda, CAN5317DMonroe City Aviators LLC · Palmyra, MON5317HHottel Cessna LLC · Prescott, AZN5317KN5317k Corp Trustee · Wilmington, DE
Back to AD 79-10-14 R1