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.
N8282BAmyx Hiram R · Liberty, TXN8282TLoveless Phillip A · Independence, KSN8283LChapin Devon S · Oxford, CTN8283UThede Dondi I · Marshall, WIN8283XWinfrey Walter A · Auburn, CAN8283ZClear Prop LLC · Bogalusa, LAN8284LMaxwell Barton W Jr · Crawfordsville, INN8285Mason Samuel A · Santa Paula, CAN8285AReim Sanford E · Fort Myers, FLN8285EJames G Loy General Contractor Inc · Punta Gorda, FLN8285FBearss Gordon M · Lawrence, KSN8285UDel Martin Lp · Spring, TXN8285XBerntsen Bradley T Trustee · Apple Valley, MNN8285ZVaughn Hollis L · Virden, NMN8286EPreston Richard R Trustee · Albuquerque, NMN8286LKyle John M · Wheeling, WVN8286M3 Jc LLC · Phoenix, AZN8286TWelch Scott P · Lovell, WYFirst renewal noticeN8287ALindholm Stanley D Trustee · Lucas, TXN8287LShirk Matthew · Auburn, INN8287MProfessional Metal Services Inc · Albion, NEN8287QAdventist World Aviation · Wilson, NCN8287XMckeever Jesse M · Indio, CAN8287ZMillion John B · Westminster, MDN8288EGomez Cierra D · Jasper, ALN8288GFord Flying Service Inc · Doerun, GAN8288MAircraft Guaranty Corp Trustee · Oklahoma City, OKN8288SWatters Reid W · Tilleda, WIN8288TDooley Kenneth J · Charleston, TNN8288XLantana Beach Flying Club · West Palm Beach, FLN8289BGodfrey Brian T · Waupaca, WIN8289FDe Cristo Andre G · Flushing, NYN8289GDutcher Kenneth J · Kingsland, TXN8289LFaust Stanley J · Nashua, NHN8289UPrice William B · Lamar, SCN828BMChristiansen Aviation LLC · Wilmington, DEN828CFChristiansen Aviation LLC · Wilmington, DEN828CPCivil Air Patrol · Maxwell Afb, ALN828EREmbry Riddle Aeronautical University · Daytona Beach, FLN828FGRidgeline Assets LLC · Wilmington, DEN828FSPerformance Aircraft Sales Inc · Lincoln, NEN828JTAtems Elisabeth · Northfield, VTN828LFFinseth Loren V Trustee · Fountain, MNN828LPFlying Twenties Inc · San Jose, CAN828PBAero Missions LLC · Zeeland, MIN828PKElizabeth City State University · Elizabeth City, NCN828RHMad Kav Properties LLC · Corona, CAN828RJNielsen Ron E · Lindon, UTN828SGSky High Aviation Of Ga LLC · Doraville, GAN828SPVista Aviation Inc · Pacoima, CA
Back to AD 79-10-14 R1