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.
N55422Boardman Thomas M · Greenwich, NYN5542BSkydive Coolidge Inc · Tempe, AZN5542CPatterson Phillip L · Knoxville, TNN5542NRegistration Pending · Denver, CORegistration pendingN5543ASelf Defense Of New England LLC DBA · Bedford, NHN5543BSvetlik Ludvik J · Victoria, TXN5543CScott Benge D · Lebanon, ORN5543EMedina Kevin S · Glendale, CAN5544CSamoilenko Sergey V · Hillsborough, NCN5544NSkydive Co · Fairburn, GAN5544RDijon Aviation LLC · Wadsworth, ILN55457Legend Air Lease LLC · Hurricane, UTN5545CJenkins Alfred G · Bangor, MEN5545GTinkham Dennis T · Leavenworth, KSN5545RCarlson Michael · Burlington, WYN5546BHeczko Eric M · Longmont, CON5546CWeinant Michael W Trustee · Fairbanks, AKN5546ERosenthal John S · Bishop, CAN5546JRegistration Pending · Danbury, CTRegistration pendingN5546RGorn Joel · Lawrence, MAN5546TMeigs Craig · Jasper, ALN5547ESissom Patrick · Hillsboro, TNN5547TGoodyear Ron L · Leo, INN5547VDahl Demar · Deeth, NVN55482Crook Mark E · Elberton, GAN5548EPowell Nathan · Columbia Falls, MTN5548RSmietanski Nathan E · Terlton, OKN5549AGeoterra Inc · Eugene, ORN5549EBacchus Tim · Tucson, AZN5549GFrantz Donna Pratt · Ocala, FLN554CTGeyer Martin J · Caro, MIN554EREmbry-Riddle Aeronautical University Inc · Prescott, AZN554TADelta Charlie Aviation LLC · Aliso Viejo, CAN554WMValdosta Flying Group LLC · Valdosta, GAFirst renewal noticeN5550BLieberherr John W · Clancy, MTN5550CBendickson Roger · Garrison, NDN5550JOptima Aviation LLC DBA · Lewisville, TXN5550RMetro Technology Centers · Oklahoma City, OKN5550TCirrus Five LLC · Merritt, NCN5550YSteiner Paul R · Boerne, TXN55515Fly Cessna LLC · Peoria, AZN5551CAer Kelly LLC · Port Orange, FLN5551TBailey Robert S · Temecula, CAN55521Carter Flygare Inc · Sacramento, CAN5552CMcqueary David L · Plant City, FLN5552EAbove And Beyond Aviation LLC · Austin, TXN5552VJust Plane Stuff Inc · Jackson, MSN5553EVogel Mark · North Bethesda, MDN5553TVan Kleek Steve D · Milford, IAN5554RRidge Rickey S · Wortham, TX
Back to AD 79-10-14 R1