Registered aircraft · 11,797

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.

N102DBFinch Air LLC · Midland, TXBuilt 1996 · S/N BB1537 N102DRCloud 9 LLC · Lafayette, LABuilt 1982 · S/N 551-0436 N102HLKopp Michael · Reno, NVBuilt 1979 · S/N E-1462 N102SBfb Enterprises LLC · Larned, KSBuilt 1979 · S/N E-1615 N102VPPrioritylab LLC · Indianapolis, INBuilt 2002 · S/N 560-0629 N102WKWillis Knighton Medical Center · Shreveport, LABuilt 1980 · S/N LA-36 N102WYWyoming Department Of Transportation · Cheyenne, WYS/N 560-0621 N1031PMartinaire Aviation LLC · Addison, TXBuilt 1994 · S/N 208B0404 N1031WBilco Air LLC · Danville, ILBuilt 1973 · S/N E-403 N1035SRegistered aircraftBuilt 2015 · S/N FL-1035 N1036S1036s LLC · Austin, TXBuilt 2005 · S/N 258704 N1036TSlaughter Terry D · Perryton, TXBuilt 1976 · S/N E-928 N1037NMartinaire Aviation LLC · Addison, TXBuilt 1993 · S/N 208B0334 N1039TJera · Johnson City, TNBuilt 1977 · S/N E-1059 N103ANCessna 208b0928 Inc Trustee · Wilmington, DEBuilt 2001 · S/N 208B0928 N103BZJet Way LLC · Brooklyn, OHBuilt 2002 · S/N 560-0617 N103CWFlying Pigs LLC · Kinston, NCBuilt 1985 · S/N FA64 N103EYSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 1150 N103LHKavalair LLC Series D · Marion, MTBuilt 1980 · S/N TH-1170 N103SEClear Prop Aviation LLC · Sioux City, IAS/N E-1099 N103SMHermack John F · Toms River, NJBuilt 1978 · S/N E-1267 N1040DMjr Aviation Consultants LLC · Clearwater, FLBuilt 2021 · S/N 208B5628 N1041LMartinaire Aviation LLC · Addison, TXBuilt 1993 · S/N 208B0337 N1044MMavel Wings LLC · Augusta, GABuilt 2016 · S/N FL-1044 N104CXSli Aircraft Leasing Inc · Spokane Valley, WABuilt 1982 · S/N BB1004 N104DTDavis Brenda Kruszewski · Middleton, IDBuilt 1981 · S/N 96010 N104EJAlliance Aviation Group LLC · Wilmington, DEBuilt 2000 · S/N 258505 N104FMEide Machinery Sales Inc · Minneapolis, MNBuilt 1999 · S/N E-3275 N104HRXyrec Inc · San Antonio, TXNon-citizen corporation, flight hours not reportedS/N 21525 N104KPLakefront Holding LLC · Racine, WIS/N LJ-1719 N104LRTri Aviation Inc · Venetia, PABuilt 1996 · S/N 258303 N104LWSt Croix Acceptance Corp · Devils Lake, NDBuilt 2013 · S/N 525-0806 N104VPJdlfox Transportation LLC · Missoula, MTBuilt 2002 · S/N 560-0619 N104VVAviation Trust Company LLC Trustee · Oklahoma City, OKS/N 53 N104WWJarosak Peter J · Valparaiso, INBuilt 1981 · S/N E-1889 N104WYWyoming Department Of Transportation · Cheyenne, WYBuilt 2004 · S/N 20800377 N1050TThrash Scott · Hesston, KSBuilt 1976 · S/N E-881 N1054WHeavers George S · Oakland, CABuilt 1973 · S/N TH-312 N1057WMaisano Abby · Hendersonville, TNBuilt 1973 · S/N E-408 N1058NAvion Capital Corp · Anchorage, AKBuilt 1993 · S/N 208B0347 N1058RWindle Air Baron LLC · Lynchburg, VABuilt 1996 · S/N TH-1791 N105BGC & K Aviation Services LLC · Wilmington, DEBuilt 1995 · S/N 560-0315 N105EV2nd Amendment Wholesale Inc · Grand Forks, NDS/N UE-64 N105JFIsr Aviation LLC · Wilmington, DEBuilt 1997 · S/N 20800272 N105RFRandigo LLC · Wilmington, DEBuilt 1993 · S/N 208B0353 N105RHJem Aviation Solutions LLC · South River, NJBuilt 1984 · S/N 650-0055 N105TBAir Force Material Command Esc/Dikl · Hanscom Afb, MABuilt 1968 · S/N 31 N105TDJcd-Gp LLC · Center, TXBuilt 2002 · S/N 560-0632 N105VEPlane Fun Inc Tr Trustee · Snellville, GABuilt 1998 · S/N 208B0680 N1060RCooper Don F · Great Falls, VABuilt 1996 · S/N E-3040

Back to AD 2006-16-18 R1