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.

N477ASAlaska Airlines Inc · Seattle, WABuilt 2015 · S/N 40716 N477JMBehrens Aircraft Leasing LLC · Waukesha, WIBuilt 1979 · S/N BB-538 N477LCPremier Aircraft Trading Service Inc · Lewes, DEBuilt 1988 · S/N S550-0153 N477MAircraft Unlimited Inc · Pierre, SDBuilt 1987 · S/N LJ-1154 N477PTGuardian Flight LLC · Lewisville, TXBuilt 2000 · S/N LJ-1600 N477USUS Department Of Homeland Security · Arlington, VABuilt 2003 · S/N 33785 N477WCAllison Medical Solutions LLC · Lumberton, MSBuilt 1977 · S/N E-1065 N477XPParaclete Aviation LLC · Raeford, NCBuilt 2000 · S/N 208B0833 N478ASAlaska Airlines Inc · Seattle, WABuilt 2015 · S/N 44105 N478CRAlg Aircraft LLC · Delano, CABuilt 1997 · S/N LJ-1474 N478PAMerlin One Aircraft LLC · San Antonio, TXBuilt 1996 · S/N 6507069 N478VTTipnes Aviation LLC · Tampa, FLBuilt 1981 · S/N 308 N479ASAlaska Airlines Inc · Seattle, WABuilt 2015 · S/N 60576 N479BCm Aviation LLC · Corsicana, TXBuilt 2002 · S/N FL-338 N479BRGunner Aviation LLC · Fayetteville, ARS/N BB-1179 N479CJLima Alpha One LLC · Newark, DEBuilt 2005 · S/N 525-0556 N479JPHogancamp John M · Lebanon, TNBuilt 1976 · S/N E-801 N479KSHaaverson Enterprises Inc · Livermore, CABuilt 1993 · S/N E-2811 N479MYMcclain Mcclain Mcclain Inc · Ridgeland, MSBuilt 1993 · S/N 525-0018 N479PTT Enterprises Inc · Jackson, MSBuilt 1981 · S/N 96011 N479RAValiair Limited Company Trustee · Casper, WYBuilt 2024 · S/N 525-1175 N479VATactical Aviation Inc · Wilmington, DEBuilt 1998 · S/N BB1601 N479WBFlyguys Aviation II LLC · Midland, TXFirst renewal noticeBuilt 2007 · S/N FL517 N47ANLagoinha Orlando Church Inc · Orlando, FLBuilt 1984 · S/N 650-0054 N47BFBoxley Farrell Aviation LLC · Roanoke, VABuilt 2024 · S/N 525-1171 N47CLAircraft Structures International Corp · Enid, OKBuilt 1987 · S/N 208B0033 N47CRCrc Air LLC · Kenner, LAS/N FL-407 N47GAJcb Air LLC · Southport, NCBuilt 1975 · S/N TH-547 N47HAHoosier Jets LLC · Sellersburg, INBuilt 1995 · S/N 258280 N47HWCelebration Tv America Inc · Houston, TXS/N 258023 N47JBBean Jackson A · Quinlan, TXBuilt 1998 · S/N E3207 N47JDQualitair LLC Trustee · MichelstadtBuilt 1980 · S/N 421C0805 N47KABroom John F · Sherman, TXBuilt 1974 · S/N E-530 N47LLSmith Roy H · Garberville, CABuilt 1947 · S/N D-972 N47PWWelkin Aviation LLC · Beaver, WVBuilt 1992 · S/N 560-0186 N47RBHolley Jack F · Morehead, KYS/N D-368 N47RTBas Part Sales LLC · Greeley, COBuilt 1997 · S/N E-3142 N47SHGc Aviation Investments LLC · Augusta, ARBuilt 1993 · S/N 525-0017 N47VBTautology Ltd · Longmont, COS/N D-936 N47VTBoyes Brothers Partnership · Benton City, MOBuilt 1947 · S/N D-730 N47WAHughston Chris · Brentwood, TNBuilt 1947 · S/N D-155 N48Federal Aviation Administration · Oklahoa City, OKBuilt 2024 · S/N FL-1347 N480AGibbs Todd D · Walford, IABuilt 1969 · S/N E-181 N480BRFive Diamond Aviation Holdings LLC · Draper, UTS/N BB1355 N480EB2020 Drt350 LLC · Lufkin, TXBuilt 2008 · S/N FL-600 N480JKAugust-Marie Inc · Wilmington, DEBuilt 1997 · S/N E3103 N480MCAtlas Air Inc · Purchase, NYBuilt 1999 · S/N 28812 N480RLBaseload Realty LLC · Corpus Christi, TXBuilt 1991 · S/N 560-0109 N4813MCouch Walter J · Patterson, LABuilt 1978 · S/N E-1265 N481ASAlaska Airlines Inc · Seattle, WABuilt 2015 · S/N 44106

Back to AD 2006-16-18 R1