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.
N97163Civil Air Patrol Inc · Maxwell Afb, ALN9716BSelkirk Associates Inc · Wilmington, DEN9716XLowe Joshua T · Mount Baldy, CAN97170Connor Catherine E · Morgantown, WVN97172C P Aviation · Santa Paula, CAN97178Meador Rita R · Eldorado, TXN9717BCeruto Jorge · Auburndale, FLN9717GBurley Mark A · North Pole, AKN9717HBullock Linda A · Shawnee, KSFirst renewal noticeN9717QRosenberger Gregg J · Keller, TXN9717VTco Inc · Stanley, NDN9717XEichner David K · Portland, ORN9718GCain Curtis S · Reno, NVN9718HDyer Stacey T · Jensen Beach, FLN9718XLooney Jeffrey J · New Boston, TXN97190Hickman Donald E II Trustee · Medford, ORN97192Atlantis Construction Inc · Friday Harbor, WAN97196N2893e LLC · Reno, NVN97199Perry Martin Dale · Denton, TXN9719VCumbie Curtis F · Fayetteville, ARN971AAHobgood David · Bartow, FLN971BBColon Hector L · Gainesville, GAN971CPCivil Air Patrol · Maxwell Afb, ALN971KCDenventures Aviation LLC · Wheat Ridge, CON971RWSutherland James P · Wausau, WIN971SPIllinois State Police · Springfield, ILN971TABanner Aviation LLC · Trabuco Canyon, CAN971THSanders Aviation Inc · Jasper, ALN97200Aragon Cecilia · Sequim, WAN9720GZarones Erik R · Paris, TXN9720MIliamna Air Taxi Inc · Iliamna, AKN9720NNash Clay S · Irving, TXN9720RPca Tail One LLC · Wilmington, DEN9720VBoobas John P · Nicholson, GAN9720XHogue Richard L · Dos Palos, CAN97211G & G 24 LLC · Clancy, MTN97218Mcgraw Thomas M II · Prescott, AZN9721GFahrenbruck George · Anchorage, AKN9721HFoster Gary P · Anchorage, AKN9721ZRwr Inc · Wasilla, AKN97220Summit Crest Capital LLC · Palos Heights, ILN97221Smith Brian A · Big Pine Key, FLN9722HQuad Cities Aero LLC · Bettendorf, IAN9722TFoust Richard W · Minneapolis, KSN9722VTck Services LLC · Millington, MIN9722XEddy David A · Gilroy, CAN97231Pacific Rim Aviation LLC · Corvallis, ORN97233Frahm Lon R · Colby, KSN97237Headley Mark E · Akron, OHN97238Sanctuary Wings LLC · Norfolk, VA
Back to AD 79-10-14 R1