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.

N522AJAj Capital Holdings LLC · The Woodlands, TXBuilt 1994 · S/N 525-0068 N522AXBc Aircraft Leasing LLC · Albuquerque, NMBuilt 1988 · S/N 48315 N522EECenergistic LLC · Dallas, TXBuilt 1999 · S/N 282 N522GLGreat Lakes Aviation LLC · Akron, OHBuilt 2010 · S/N 525-0697 N522KLClearview Investments LLC · Lexington, TNBuilt 2016 · S/N 525-0939 N522MJPpr2 Inc · Jackson, MSS/N LW-80 N522SATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2024 · S/N 208B5819 N522TGSe Express LLC · South Lyon, MIBuilt 1985 · S/N BB-1209 N522WPM & M Aviation LLC · Lincoln, NEBuilt 2016 · S/N 525-0924 N523AMSigma Aviation LLC · Vancouver, WABuilt 1981 · S/N E-1723 N523ASWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 35194 N523CHawk Unlimited LLC · Kalispell, MTBuilt 1998 · S/N E-3161 N523YATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1995 · S/N 560-0291 N5245NSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1947 · S/N D-109 N524ASAlaska Airlines Inc · Seatac, WABuilt 2009 · S/N 35195 N524CBTechnical Film Systems Inc · Camarillo, CABuilt 1991 · S/N TH-1630 N524CDDriscoll Cindy M · Savannah, TNBuilt 1968 · S/N E-81 N524CNSchuele Hans-Peter · Wichita Falls, TXBuilt 1984 · S/N E-2144 N524MRMt King Air · Stevensville, MTBuilt 1979 · S/N BB524 N524PAPhoenix Air Group Inc · Cartersville, GABuilt 1975 · S/N 033 N524PCKlingaman Katherine R · Dallas, TXS/N FL-447 N524RTN524rt LLC · Greensboro, NCBuilt 1970 · S/N TH-123 N524TFBgmg LLC · San Antonio, TXBuilt 2022 · S/N 525-1136 N5255BWest Wind Air LLC · Lake Village, ARBuilt 1997 · S/N 525-0231 N525AQM2ntt LLC · Houston, TXBuilt 2024 · S/N 525-1164 N525ASAlaska Airlines Inc · Seatac, WABuilt 2009 · S/N 35692 N525AWD And D Aviation LLC · Tahoe City, CABuilt 2000 · S/N 525-0369 N525BDN300bb LLC · Melbourne Beach, FLBuilt 2026 · S/N 525-1407 N525BPPmi Aviation LLC · Fishers, INBuilt 2002 · S/N 525-0479 N525BRDk Aviation LLC · Pittsford, NYBuilt 2001 · S/N 525-0444 N525BTWhiting Wings LLC · Alexander, ARBuilt 1996 · S/N 525-0161 N525BWRegistered aircraftBuilt 2000 · S/N 525-0409 N525CJettech Holdings LLC · Broomfield, COBuilt 1999 · S/N 525-0332 N525CAWb Aviation LLC · Sugar Grove, ILBuilt 1981 · S/N E-1797 N525CDLincoln Transport D LLC · Newark, DEBuilt 2000 · S/N 525-0360 N525CHRebus II LLC · Owasso, OKBuilt 1994 · S/N 525-0078 N525CMD Bar K LLC · Gatesville, TXBuilt 1995 · S/N 525-0093 N525CPAdios Aviation LLC · Austin, TXBuilt 1997 · S/N 525-0228 N525CXCentrex Construction Inc · Tigard, ORBuilt 2011 · S/N 525-0700 N525DCMalmstrom White Co · Little Rock, ARBuilt 1997 · S/N 525-0195 N525DFBleu Cheese Aviation II LLC · Addison, TXBuilt 2000 · S/N FL-306 N525DPElk Factoring LLC DBA · Staunton, VABuilt 1999 · S/N 525-0318 N525DTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1994 · S/N 5250062 N525DUFtc Air Holdings 2 LLC · Tampa, FLBuilt 1997 · S/N 525-0205 N525EBellevue Advisors LLC · San Mateo, CABuilt 2014 · S/N 525-0853 N525FCExponential Thinking LLC · Houston, TXBuilt 2004 · S/N 525-0531 N525FNMci Air LLC · Dover, DEBuilt 2000 · S/N 525-0368 N525FSWrb Aircraft Leasing LLC · Wilmington, DEBuilt 2002 · S/N E-3445 N525GCSav Aviation LLC · Jacksonville, TXBuilt 1994 · S/N 5250065 N525GEKek Companies Inc · Portland, ORFirst renewal noticeBuilt 2008 · S/N 525-0679

Back to AD 2006-16-18 R1