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.
N8512SDoss Jacob · Casco, MIN8512TRegistration Pending · Odessa, TXRegistration pendingN8513BFisher Steven B · Kuna, IDN8513JHurd Billy R · North Pole, AKN8513SBeach Thomas C III · Salado, TXN8514QAvila Robert A · Lawrence, MAN8514TCombee Ann W · Winter Haven, FLRegistration expired, pending cancellationN8514UDyck Johan · Key Largo, FLN8514XPeck Eldon G · Grace, IDN8515SHawkins Kenneth Roger · Globe, AZN8515TGraham Richard · Farmingdale, NYN8516BEdson David V · Ionia, IAN8516MSealane LLC · Burlingame, CAN8516SReik Thomas Donaldson Jr · New Port Richey, FLN8517STardif Jean Y · Moorpark, CAN8517TWahl John Jr · Yelm, WAN8517UNortheast Cubs LLC · Wilmington, DEN8518GDouble Rr Holdings LLC · Dallas, TXN8518XHepner Karl E Jr · Clifton, VAN8519GSullivan Aviation Maintenance LLC · Fayetteville, NCN8519SCinden LLC · Nashua, NHN851AKIncline Tahoe Ventures LLC · Incline Village, NVN851CAT&B Aero LLC · Jacksonville, FLN851CBTextron Aviation Employees Flying Club Inc · Wichita, KSN851CPCivil Air Patrol · Maxwell Afb, ALN851DABhh Leasing #4 LLC · Pensacola, FLN851EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN851LW578 Airplane Leasing Inc · Kissimmee, FLN851MDKiko Peter R · Dalton, OHN851SPLegends Air Center LLC · Bentonville, ARN8520BCook Mike R · Rye, CON8520SClark Joseph D · Kilgore, TXN8520XJohn Robert W Jr · Andrews, TXN8521BHiebert Isaac G · Hachita, NMN8522JValley Jacob A · Brewer, MEN8522TWicklander Richard O · Spanaway, WAN8522UHebbronville Machine Shop Llp · Hebbronville, TXN8523GStephany Peter T · Umatilla, FLN8523QLifetime Adventures LLC · Bellevue, MIN8523THorning Jason R · Seffner, FLN8523UEllis Clifford E · Emmitsburg, MDFirst renewal noticeN8524BBecker Robert A · Santa Rosa, CAN8524SLoyer Victor D · Palmer, AKN8524TMurlin David · Hemet, CAN8524ULewis Steven · Anchorage, AKN8524XPedroza Everett W · Tehachapi, CAN8525JBicknell Hilary E · Warwick, RIN8525TSmith Randall M · Escondido, CAN8525XBradford John R · Sheridan, ARN8526BMallory John C · Fairbanks, AK
Back to AD 79-10-14 R1