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.

N9218Omega Air Inc · Selma, TXS/N 48218 N921ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29522 N921AZArizona Department Of Public Safety · Phoenix, AZBuilt 1988 · S/N BB-1287 N921BETmg Aircraft Holdings LLC · New Port Richey, FLS/N 501-0174 N921BSOld Dominion Aviation LLC · Statesville, NCBuilt 1993 · S/N FL-110 N921DUBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 63532 N921FEFederal Express Corporation · Memphis, TNBuilt 1987 · S/N 208B0021 N921MFPuerto Coral Corp · Wilmington, DEBuilt 1980 · S/N LA62 N921NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 33229 N921WTMission Aviation Fellowship · Nampa, IDBuilt 2025 · S/N 208B5858 N921XTSundance Mc LLC · Dallas, TXBuilt 2015 · S/N 525-0877 N9226QBelanger Bobby Lee · New Braunfels, TXBuilt 1971 · S/N E-284 N9228ZN9928z LLC · Greeley, COS/N S550-0057 N922ACGlenville Aviation LLC · Lake George, NYBuilt 1992 · S/N 560-0187 N922ALBallard Aviation Inc · Newton, KSS/N BB1529 N922ANAmerican Airlines Inc · Forth Worth, TXBuilt 1999 · S/N 29523 N922CWAngel Flyers LLC · Charlottesville, VABuilt 1994 · S/N E-2886 N922DZBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 64886 N922EHWolf Rock Industries Inc · Huntington Beach, CABuilt 1979 · S/N 551-0122 N922FEFederal Express Corporation · Memphis, TNS/N 208B0022 N922HBPovero Marcus E · Fort Worth, TXBuilt 1977 · S/N TH-825 N922JCSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2002 · S/N LJ-1665 N922KGGaka LLC · Jal, NMBuilt 1992 · S/N 560-0167 N922KMRosado Aviation Inc · Moosic, PABuilt 1998 · S/N 650-7087 N922NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 29574 N922TRCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1988 · S/N RJ44 N922TXWheeler Trailer Inc · Chicago, ILBuilt 2008 · S/N 560-0789 N9239QRegistration Pending · Bessemer, ALRegistration pendingBuilt 1971 · S/N TH-139 N923AKHenderson Alexander · Zephyr Cove, NVBuilt 1971 · S/N E-285 N923ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29524 N923ASDjp Properties LLC · Selma, CABuilt 1979 · S/N BB-541 N923CRWc&R LLC · Austin, TXBuilt 1984 · S/N LJ-1074 N923DZDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 64887 N923FEFederal Express Corporation · Memphis, TNBuilt 1987 · S/N 208B0023 N923FPF M P Enterprises LLC · Yakima, WABuilt 2014 · S/N FL-921 N923JKMs Avation LLC · Waukesha, WIS/N FL-40 N923NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 31167 N923RLUrquhart Kris · Fallon, NVBuilt 2004 · S/N E3537 N923TBCaffey Distributing Company Inc · Greensboro, NCBuilt 2024 · S/N 525-1166 N923TRCareer Aviation Co Inc · Wilmington, DES/N 28923 N924ACDena'Ina Air Taxi LLC · Anchorage, AKBuilt 1979 · S/N BB483 N924ANWilmington Trust Co Trustee · Wilmington, DEBuilt 1999 · S/N 29525 N924DZBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 63536 N924JBN924jb LLC · Little Rock, ARBuilt 2004 · S/N BB-1849 N924KGHairston Hollie Brenton · Bryan, TXBuilt 1979 · S/N E1507 N924NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 33486 N924RBHitendra Chaturvedi · Chandler, AZBuilt 1979 · S/N E-1612 N924RHSmith Joelene K · Avon, INBuilt 1978 · S/N E-1288 N924SDGrimmius Air LLC · Tulare, CABuilt 2010 · S/N FL-693 N924XSchieffer Enterprises LLC · Kurten, TXBuilt 2015 · S/N 525-0865

Back to AD 2006-16-18 R1