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.
N5339DTang Hong-Ming · San Dimas, CAN5339HBering Capital LLC · Anchorage, AKN5339KNordell Kent D · Staples, MNN5339MM&M Management Group LLC · Englewood, CON5339NMaine State Police · Augusta, MEN533BMGray Ronald P · Glendale, AZN533KAKamaka Air LLC · Honolulu, HIN533KSKent State University · Stow, OHN533SJLns LLC · Wichita, KSN533TDChristopher Schultheis Inc · Colton, WAN53402Anvab Inc DBA · Concord, NHN5340CCustis James G · Friday Harbor, WAN5340TRundell Lanny · Winnsboro, LAN5340XAgvest LLC · Abingdon, VAN5340YCripe Michael L · San Luis Obispo, CAN53417Eastern Cincinnati Aviation Inc · Batavia, OHN53418N53418 LLC · Orlando, FLN5341HHoffman Calhoun E · Barnwell, SCN53420Kropp Christian Trustee · Azle, TXN5342CPig Aero LLC · Aurora, ILN5342DCornell Timothy R · Hartland, WIN5342QBoard Of Trustees Of Southern Illinois University · Murphysboro, ILN5342SFranco Gloria J · Las Vegas, NVN5342TLima-001 LLC · Muscatine, IAN5342YAmeriflyers Of Texas Inc · Addison, TXN53434Caswell Jeff S · Durham, CAN53437Vineyard Eddie E · Wapello, IAN5343BSkydive Moab LLC · Moab, UTFirst renewal noticeN5343DHusnik Brad M · Forest Lake, MNN5343RMcmahon Michael E · Porterfield, WIN53440Air Spacers Inc · Santa Monica, CAN53449Hyde Russell M · Rutherfordton, NCN5344CThomas Robert S · Caddo Mills, TXN5344DAirgo Inc · Centralia, ILN5344FWingsleasing LLC · Wichita, KSN5344HA&F Aviation Services LLC · Collierville, TNN5344KBoeing Employees Flying Assoc · Renton, WAN5344QGraber Quinten R · Brooksville, MSN5344RMoxley Michael D · Spearfish, SDN53456Amelia Reid Aviation LLC · San Jose, CAN5345QRegistered aircraftN5345TBerrong Jimmy L Sr · Dahlonega, GAN5345UMidwest Avtech Inc · South Barrington, ILN53460L & W Leasing LLC · Smyrna, TNN53463Fara Nick · San Anselmo, CAN53468Maya Aircraft Holdings LLC · Lee, NHN5346BSale Reported · Jasper, TXSale reportedN5346DBoldflight LLC · Greenwood, INN5346EOsprey Holding Company LLC · Foley, ALN5346KUsaeroflight LLC · Greenville, SC
Back to AD 79-10-14 R1