Registered aircraft · 11,798

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

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:2006-16-18-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:2006-16-18-R1') ORDER BY n_number

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:2006-16-18-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:2006-16-18-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:2006-16-18-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:2006-16-18-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.

N910TRDutch Aviation LLC · Perry, IABuilt 1997 · S/N 560-0440 N910WWLundell Plastics Corp · Odebolt, IABuilt 2004 · S/N TH-2092 N911CACalifornia Highway Patrol · Sacramento, CABuilt 2005 · S/N FL-462 N911CFCustom Flight Rnh LLC · New Richmond, WIBuilt 1979 · S/N LA-13 N911CMPhi Health LLC · Tempe, AZBuilt 1996 · S/N BB-1551 N911CXCentral Virginia Aviation Inc · Petersburg, VAFirst renewal noticeBuilt 1979 · S/N LJ-830 N911DMPort Townsend Aero Museum · Port Townsend, WABuilt 1947 · S/N D-1118 N911DQDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 64882 N911FNApollo Aviation LLC · Las Vegas, NVBuilt 1976 · S/N LJ-688 N911GSAir-Ric LLC · Mobile, ALBuilt 1981 · S/N E-1785 N911KADavis Aviation DBA · Brandon, MSS/N FA-44 N911QJean Burkholder And Glen Ellis LLC · Midland, TXBuilt 1997 · S/N 5250220 N911RLDale Aviation Inc · Rapid City, SDBuilt 1989 · S/N LJ-1219 N911RXReach Air Medical Services LLC · Santa Rosa, CABuilt 1992 · S/N BB-1425 N911SFReiner Russell · Redding, CABuilt 1999 · S/N BB-1659 N911WTFernandez Daniel · Boca Raton, FLBuilt 1986 · S/N E-2298 N911ZCValiair Lc Trustee · Casper, WYS/N LJ-1557 N911ZEGilgal Stones Consulting LLC · Flint, TXS/N LJ-1358 N9127QDopfel Bruce E · Belle Plaine, KSBuilt 1971 · S/N E-245 N9128QRegistered aircraftBuilt 1970 · S/N E-247 N912ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29513 N912DPVista Services LLC · Madison, WIBuilt 2001 · S/N 560-0575 N912DUDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 64883 N912FEFederal Express Corp · Memphis, TNBuilt 1986 · S/N 208B0012 N912MH James & Sons Inc · Fennimore, WIBuilt 2001 · S/N E-3379 N912MNAvera Mckennan · Sioux Falls, SDBuilt 1993 · S/N BB1468 N912NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 33319 N912SCCrest Five Associates Inc · Breinigsville, PABuilt 1991 · S/N TH-1646 N912SVSaint Vincents Healthcare · Billings, MTBuilt 1988 · S/N BB-1299 N9134SDaytona Aircraft Services Inc · Daytona Beach, FLS/N TH-726 N9136QBeech 9136q Charter Aircraft LLC · Chico, CABuilt 1970 · S/N E-248 N9136SProctor Racing Group LLC · Glendora, CABuilt 1976 · S/N E-844 N9137SCiontea James C · Santa Barbara, CABuilt 1976 · S/N E-820 N9139QBollings Avionics LLC · Bristol, TNBuilt 1970 · S/N E-249 N913ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29514 N913BJLanier Equipment Leasing LLC · Gainesville, GABuilt 1989 · S/N 560-0011 N913CKKalitta Charters LLC · Ypsilanti, MIBuilt 1975 · S/N 013 N913DSHaulin Ash Productions Inc · Franklin, TNS/N E-3523 N913DUDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 62781 N913NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 29571 N913RXReach Air Medical Services LLC · Santa Rosa, CABuilt 1993 · S/N BB-1471 N913SCAircraft Holding Solutions LLC · Newark, DES/N NA0418 N913TDJwt Equipment LLC · Springdale, ARBuilt 2001 · S/N 525-0468 N9144QN9144q LLC · Brooklyn, NYBuilt 1970 · S/N E-250 N914ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29515 N914DKCal-Ore Life Flight LLC · Brookings, ORBuilt 1996 · S/N LJ-1445 N914DUDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 62782 N914ECPacific Rim Management LLC · Downey, CAS/N 258001 N914FEFederal Express Corporation · Memphis, TNBuilt 1987 · S/N 208B0014 N914JALake Area Technical College · Watertown, SDBuilt 1989 · S/N FA-191

Back to AD 2006-16-18 R1