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.

N46JXKing Air 3au LLC · Wichita, KSBuilt 1981 · S/N LA171 N46KASouthern Ionics Inc · West Point, MSBuilt 2021 · S/N FL-1281 N46KKHuff Air LLC · Uvalde, TXBuilt 2018 · S/N 525-1013 N46LDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1978 · S/N BC-56 N46LEKepley Aviation LLC · Smyrna, TNS/N E726 N46MKSplendid Jet Lease LLC · Cape Coral, FLS/N 206 N46RFUnited States Department Of Commerce · Lakeland, FLBuilt 1985 · S/N 824 N46RPJst Management LLC · Zephyrhills, FLBuilt 1976 · S/N LW-193 N46SBDavis Aviation Inc DBA · Brandon, MSS/N LW-312 N46WDCdg Express LLC · Hernando, MSBuilt 1991 · S/N FL-38 N46WSCahoon Theodore J · Erie, COBuilt 1948 · S/N D-1253 N470KAKerola Aviation Inc · Masury, OHBuilt 1993 · S/N FL-109 N470MMSfc Global Supply Chain Inc · Marshall, MNBuilt 2000 · S/N UE-394 N471ASAlaska Airlines Inc · Seattle, WABuilt 2014 · S/N 41703 N471BWPatriot Environmental LLC · Meeker, OKS/N 421C0640 N471DAero Food Imports LLC · Dover, DEBuilt 1962 · S/N 500A-1240-70 N471DSBoeing Co · Renton, WABuilt 2025 · S/N 68737 N471EVGugu Ltd · Bellevue, WAS/N 20651 N471MCAtlas Air Inc · White Plains, NYBuilt 1997 · S/N 26557 N471MDCitation Management LLC · Pelham, ALBuilt 1995 · S/N 525-0122 N4728MHitchins Michael B · Lake Havasu City, AZBuilt 1978 · S/N E-1256 N472ASAlaska Airlines Inc · Seattle, WABuilt 2015 · S/N 60580 N472EAWashington State Community College · Spokane, WAS/N LW-250 N472EVFletcher Aviation Services LLC · Bismarck, NDBuilt 1971 · S/N 20320 N4733MNelson Steven L · Hampton, MNBuilt 1978 · S/N TH-927 N4734MMiller Carl J · San Dimas, CABuilt 1978 · S/N E-1257 N4736MAmp Air LLC · Gulf Shores, ALBuilt 1985 · S/N E-2243 N4738MRetter Christpher · Lynn, INBuilt 1978 · S/N E-1258 N473DBTrans Air LLC · Helena, MTBuilt 1996 · S/N 525-0129 N473SA1st Avenue Malibu Services LLC · Los Angeles, CAS/N E-3473 N473TWNv5 Geospatial Inc · Sheboygan Falls, WIBuilt 2001 · S/N 208B0894 N47414United Airlines Inc · Chicago, ILBuilt 2008 · S/N 32827 N474ASAlaska Airlines Inc · Seattle, WABuilt 2015 · S/N 40715 N474CFCarrousel Aviation LLC · Monroe, WIBuilt 2004 · S/N 258662 N474LCAlpine Aviation Inc · Provo, UTBuilt 1993 · S/N UE-74 N474PECarolina Jet Partners LLC · Greenville, SCBuilt 1998 · S/N 560-0474 N4759MTempel Warren K · Longmont, COBuilt 1978 · S/N E-1300 N475BVinyard Robert L Jr · Borger, TXBuilt 1948 · S/N D-1493 N475ECGarcia Paola Olivares · El Paso, TXBuilt 1979 · S/N E-1446 N475HMFalcon Double D 163 LLC · Fort Lauderdale, FLBuilt 1999 · S/N 258451 N475JGwaltney Air Inc · Alexander City, ALBuilt 1994 · S/N E-2883 N475JMSmm Aviation LLC · Destin, FLBuilt 2001 · S/N E-3368 N475RSRomeo Sierra LLC · Morgantown, WVBuilt 2004 · S/N 258674 N475USUS Department Of Homeland Security · Arlington, VABuilt 2004 · S/N 33789 N4766MFx5 Construction & Excavation Inc · Decatur, TXBuilt 1978 · S/N E-1259 N476EWWny Air Inc · Dover, DEBuilt 1996 · S/N TH-1797 N476JMJp Air LLC · Kalispell, MTBuilt 1979 · S/N E-1397 N476LCL-3 Is LLC · Kalispell, MTBuilt 1986 · S/N S550-0091 N476PBAerotrust Services Corp Trustee · Wilmington, DEBuilt 2015 · S/N FL-1032 N4776MPassion Aviation LLC · Bells, TXBuilt 1978 · S/N LJ-776

Back to AD 2006-16-18 R1