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.
N8595GLazy 8 Flying Service LLC · Polson, MTN8595UMoore James F Jr · Alexandria, KYN85965Burn Gray P · North Stonington, CTN8596JNelson David D · Mercer, PAN8596UAtlanta Air Academy LLC · Kennesaw, GAN8597UMrd Aero LLC · Manheim, PAN85988Wilson Miles · Mcminnville, TNN8598QTolley Samuel M · Rangely, CON8598SBradley Christopher J · Left Hand, WVN8598TFoster Jacob D · Parker, CON8598UMcclay Andrew · Baker City, ORN85992Mildenburger Frederick E · Scottsburg, INN8599BPruett Mike A · Springdale, ARN8599GBoatright Michael L · Live Oak, FLN8599QForbes Paul J · Anchorage, AKN8599SMcclung Malcolm J · Ripon, WIN8599TRegistered aircraftN859ALAms Aviation LLC · South Bend, INN859BABarr Air Patrol LLC · Mesquite, TXN859CPN859cp LLC · Boynton Beach, FLN859DAb Prop Plane II LLC · Metairie, LAN859DLBryant Charles Martel · Dallas, TXN859JANational Aircraft Leasing · Greenville, DEN859JTRainier Flight Service LLC · Renton, WAN859SPJet Air Inc · Iowa City, IAN859ZSeneca Flyers Inc · Waterloo, NYN85ACSusten LLC · Austin, TXN85AJBha Leasing Inc · South Portland, MEN85BBennett Dennis Lane Jr · Hastings, MIN85BPPearce William · Grants Pass, ORN85CFSutton Aircraft Salvage LLC · Palmer, AKFirst renewal noticeN85DTPolashenski Christopher · Fairbanks, AKN85EFRegistered aircraftN85FFFf22 LLC · Scottsdale, AZN85GH185f LLC · East Troy, WIN85GKSale Reported · Yonkers, NYSale reportedN85JAFrequency Change Aviation Services Inc · Nashville, TNN85JWWhittington Robert W · Blackwell, OKN85JXKahonees Air Service LLC · Bozeman, MTN85KAMancini Christopher S · Houston, TXN85LCCoyote Air LLC · Fairbanks, AKN85LZJacques Jerry J · Iliamna, AKN85NEvans Thomas P · Hollow Rock, TNN85PEMidwest Airmotive Inc · Mount Sterling, KYN85QAmiculum LLC · Black Eagle, MTN85RN85 Romeo Group Lp · Wildwood, MON85SJSweet Jesus LLC · Ridgely, MDN85SNSn Inc · Seattle, WAN85SSCornelius John W · Elgin, TXN85TBurbanks Travis · Woodland Hills, CA
Back to AD 79-10-14 R1