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.
N96061Wold Wayne T · Wasilla, AKFirst renewal noticeN9606BAnderson David R · Sycamore, ILN9606GJack Leasing Services Inc · Duchesne, UTN9606XRowland Douglas · Wichita, KSN9607AAdams Teresa M Trustee · Granbury, TXN9607HTwin Oaks Airpark Inc · Hillsboro, ORFirst renewal noticeN9607XBaldridge Steven J · Edmonds, WAN9607YIsn Aviation LLC · Loup City, NEN9608GCopper River Airmotive LLC · Copper Center, AKN9608HCag Aircraft Holdings LLC · Crystal River, FLN9608QLahmers Melvin E · Newcomerstown, OHN9608XEsdaile Philip J · Woodland, CAN9609QWestrup Gregory W · Greensburg, INN960AUAuburn University · Auburn, ALN960CPCivil Air Patrol · Maxwell Afb, ALN960FSSouthern Aero LLC · Homestead, FLN960MSMt San Antonio Community College District · Walnut, CAN960TAInnoutaero LLC · Stockton, CAN96100Trajectory Aviation LLC · Hollywood, FLN96105Demon Air LLC · Palm City, FLN9610AJackson William P · Littlerock, CAN9610GChoice Aviation LLC · Hamilton, MTN9610QUS Aviation Group LLC · Denton, TXN9610TMulkey Randall L · Wellston, OKN9610XSutton George E · Fullerton, CAN9611HTarheel Aviators LLC · Cary, NCN9611XWinston Air LLC · Haleyville, ALN9612AKm Aero Inc · Kalispell, MTN9612G4-F Flyers LLC · Haysville, KSN9612HRegistration Pending · Ocean Isle Beach, NCRegistration pendingN9612RBearnose II LLC · Edina, MNN9613BLiebsch Mark W · Reno, NVN9613GDavid W Easter Consulting Inc · Libby, MTN9613HFiedler Mark · Wichita, KSN9613TMilleman Barry M · Monticello, INN9613ZAlosanel Charter Inc · Concord, NHFirst renewal noticeN9614HC&H Elite Air LLC · Johnstown, CON9614QConrad Terry E · Lancaster, OHN9614TLucas Lester L · Napa, CAN9614XMountain Air Flying LLC · Brigham City, UTN9615ADay Michael J · Fort Wayne, INN96167Westrum Durl Troy · Norwalk, IAN9616ELove James H · Springville, ALN9616LMid Island Air Service Inc · Ronkonkoma, NYN9616QClearview Flying Club Inc · Westminster, MDN9616XJim Barrett Photography Inc · Honolulu, HIN96177B2 Cpr Plus Inc · Bermuda Dunes, CAN9617HShinn Lake D · Stevensville, MTN9617QKagin Corp · Wilmington, DEN9617ZWright William F Trustee · Anchorage, AK
Back to AD 79-10-14 R1