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.

N529TATodhunter Aviation LLC · Wilmington, DEBuilt 2019 · S/N 525-1037 N529TGJet Connection LLC · Hamilton, OHBuilt 1999 · S/N 560-0497 N52CSpritzair LLC · North Palm Beach, FLBuilt 1981 · S/N BB-992 N52CEUlmer Ken W · Houston, TXS/N E-3495 N52GSLqp Aviation LLC · Gary, SDBuilt 1968 · S/N E-122 N52KACentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1973 · S/N LW-42 N52KTMontgomery Transit LLC · Fulton, MSS/N E-3391 N52KXZb Air LLC · Broken Arrow, OKBuilt 1998 · S/N 525-0287 N52SBRedwood Oil Co Inc · Rohnert Park, CABuilt 1978 · S/N E-1274 N52TEThumb Aviation LLC · Bad Axe, MIBuilt 2016 · S/N 208B5269 N52TLN52tl LLC · Phoenix, AZS/N 501-0053 N52VSVista Strategies & Solutions Group LLC · Hendersonville, NCS/N LW-301 N52WFBas Part Sales LLC · Greeley, COBuilt 1999 · S/N 560-0528 N52ZGLift Aviation LLC · Aspen, COBuilt 2015 · S/N 525-0891 N53Textron Aviation Inc · Wichita, KSS/N FL-1381 N530ASAlaska Airlines Inc · Seattle, WABuilt 2010 · S/N 36578 N530CLGilgal Stones Consulting LLC · Flint, TXS/N S550-0094 N530DLTaylor Aero LLC · Lewes, DES/N 287 N530LMCorsair Two LLC · Hillsboro, ORBuilt 1999 · S/N BB1678 N530SRDavis & Floyd Aviation LLC · Greenwood, SCBuilt 2015 · S/N FL-991 N531ASAlaska Airlines Inc · Seattle, WABuilt 2010 · S/N 35199 N531AWCsi 135 Division LLC · Albuquerque, NMBuilt 1986 · S/N FA-98 N531BROvation Of Columbia LLC · Augusta, GAS/N 525-0264 N531BXMcguire Aviation LLC · Post Falls, IDBuilt 2018 · S/N FL-1154 N531CBSpectre Aviation LLC · Dover, DEBuilt 1983 · S/N BE-133 N531KCConstantine LLC · Fort Collins, COBuilt 1985 · S/N TH-1484 N531LMCorsair Two LLC · Hillsboro, ORFirst renewal noticeS/N BB1852 N531PPerair Corp · Manhasset Hills, NYS/N 93 N532ASAlaska Airlines Inc · Seatac, WABuilt 2010 · S/N 36346 N532AWCsi Aviation Inc · Killeen, TXBuilt 1991 · S/N FA-218 N532GMsd Sales Inc · Cedar Rapids, IABuilt 1977 · S/N E-1038 N532LMCorsair Two LLC · Hillsboro, ORBuilt 2007 · S/N BB-1996 N533ASAlaska Airlines Inc · Seatac, WABuilt 2011 · S/N 35201 N533GGClf Houston Travel LLC · Houston, TXBuilt 1998 · S/N LJ-1533 N533PJWorldwide Option LLC · Lewes, DEBuilt 1984 · S/N 501-0683 N533SSMacon King Air 90 LLC · Dover, DEBuilt 1976 · S/N LW-197 N533XRegistered aircraftBuilt 1985 · S/N E-2234 N53441United Airlines Inc · Chicago, ILS/N 30131 N53442United Airlines Inc · Chicago, ILBuilt 2009 · S/N 33536 N5349B39 Bravo LLC · Wilmington, DEBuilt 1988 · S/N E-2416 N534ASAlaska Airlines Inc · Seatac, WABuilt 2011 · S/N 35202 N534AWCsi Aviation Inc · Killeen, TXBuilt 1988 · S/N FA154 N534HHec Aviation LLC · Shelbyville, TNBuilt 1991 · S/N 650-0196 N535Citation Jet 535 LLC · Moultrie, GABuilt 2001 · S/N 525-0445 N5355JRusty Simpson LLC · Nemo, TXS/N 421C0669 N535ASAlaska Airlines Inc · Seattle, WABuilt 2011 · S/N 35200 N535BPBum Aviation LLC · Green Bay, WIBuilt 2003 · S/N 560-0646 N535PNDavis Aviation Inc DBA · Brandon, MSS/N FA-152 N535SATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2024 · S/N 208B5820 N5366XTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2017 · S/N 208B5366

Back to AD 2006-16-18 R1