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.
N6045GWalls Sales LLC · Poplar Bluff, MON6045JCavender Michael J · Tucson, AZN6045TSaladino Michael J · Metairie, LAN60463Angeltown LLC · Covina, CAN6046ADickerson Danny W · York, SCN6046KAl-Rubaiie Haider A · Fort Worth, TXN6046NPappas Joshua · Wilmette, ILN6046TDimaio Joseph V · Leesville, LAN60470Lowry John R · Mexico, MON60474Koeck Max IV · Metairie, LAN60475Blair Shawn C · Mandeville, LAN60477Edwards Blake A · Greensburg, KYN6047AJames Theodore B · Marine St Crx, MNN6047BOliver Ross C Trustee · Eagle River, AKN6047RSwanson Brad J · Yakutat, AKN60484Erb Charles A · Holden, MEN60487Mac Mor Ltd · East Troy, WIN6048GWitthuhn Johnie B · Callaway, NEN6048JAll Elements Aviation LLC · Newnan, GAN6048NAero-Mach Labs Inc · Wichita, KSN6048ZRegistration Pending · Wilmington, DERegistration pendingN60492Saint John Harold James · Arvada, CON60494Heilmann Charli E · Martinsburg, WVN60499Marion Military Institute · Marion, ALN6049AMetcalf Nate J · Hooker, OKN6049JKyne James M Jr · Vacaville, CAN6049RSmith Timothy John · Parkville, MDN604EREmbry Riddle Aeronautical University Inc · Prescott, AZN604MSHawaiian Airlift Company Llp · Kihei, HIFirst renewal noticeN604NDHeavy Metal Air LLC · Farmingdale, NYN604RDSaint Aviation Ministry LLC · Ozark, MON604TTUniversity Of Alaska Anchorage · Anchorage, AKN60502Janak Jeffrey J · Corpus Christi, TXN60505Mcbride Kristi L · Lexington, OKN60509Sutton Aircraft Salvage LLC · Palmer, AKN6050GNihan Gregory K · Hanson, MAN6050JTri-M LLC · Nikiski, AKN60510Hansen Larry G · Alliance, NEN60515Ristevski Bill · Vacaville, CAN6051ABlair Marion J · Lafayette, LAN6051BGmr Leasing LLC · Lincoln, DEN6051JRobison David · El Dorado, ARN6051RSpalding David · Ketchum, IDN6051UVigil Gabriel M · Mora, NMN6051VBucelluni Brett · Cypress, TXN60522Red Sky Aviation LLC · Livermore, CAN60529My Holdings Inc · Anchorage, AKN6052APhillips Roberta L · Riverside, CAN6052KCollins Robert E · Belleville, ILN60532Duffy James F · Hudson, WI
Back to AD 79-10-14 R1