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.
N9676BAnselment Barney A · Polson, MTN9676HErickson Paul F · Wasilla, AKN9676VCronsell Christopher A · Muskego, WIN9676XMoore Samuel B · Tucson, AZN96775Christiansen Aviation LLC · Wilmington, DEN9677QKodiak Flying Club Inc · Kodiak, AKN96783Campbell George A · Aubrey, TXN96784Arnett William J · Heber Springs, ARN96788Lewis Garry L · Livingston, LAN9678HBuckles Edward W II · Mechanicsburg, ILN9678QNorthgate Aviation Inc · Chico, CAN96792N96792 LLC · Shrewsbury, MAN96798Curl Kathryn Ann · Idaho Falls, IDN9679AEquinoxx Flight Systems LLC · Lawrenceville, GAN9679BRuehle Alex A · Denver, CON9679QEagle Sky Patrol Inc · Deadwood, SDN9679XMurphree David A · Lake Saint Louis, MON967AAWings Over Texas Holdings LLC · Denton, TXN967AEKreil Curtis L · White City, ORN967CPCivil Air Patrol · Maxwell Afb, ALN967DGPersinger Kenneth W · Fairbanks, AKN967JRAmoroso Ricardo C · Powder Springs, GAFirst renewal noticeN967LTUniversity Of La System DBA · Ruston, LAN967SAElizabeth City State University · Elizabeth City, NCN96804Petecraft Aviation Services Inc · Plains, GAN96808Hill William G Trustee · Laguna Niguel, CAN96809Folsom Realty Group Inc · Greenville, MEN9680QAircraft Guaranty Corp Trustee · Oklahoma City, OKN9681Srividya Aviators LLC · North Brunswick, NJN96810Gordin Michael E · Lakeland, TNN96814Airplane Leasing LLC · Jupiter, FLFirst renewal noticeN9681AKablau Frank · Elroy, WIN9681FSplashdown Aviation LLC · Dunedin, FLN9681HDavis Lester Jr · George West, TXN9681VCooperative Cross Roads Flying Club · Albuquerque, NMN9681XCentral Aviation LLC · White City, ORN96821Tdm Aviators LLC · Madison, ALN9682APenfield George R · Shreveport, LAN9682HCloutblazer LLC · Sacramento, CAN9682VBanks Michael R · Macon, MSN96836Visalia Flyers LLC · Visalia, CAN96839Eastern Shore Aviation · Onancock, VAN9683ARogers Wallace B · Salem, ORN9683BTita Enterprises LLC · Apex, NCN9683HCook Samuel Jordon · Thibodaux, LAN9683QBering Capital LLC · Anchorage, AKN9683TFroes Carlos D · Avondale, AZFirst renewal noticeN9683XBates Roger · Palm Beach Gardens, FLN96840Brad Force One LLC · Terre Haute, INN96843Southside Air LLC · Bakersfield, CA
Back to AD 79-10-14 R1