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.

N918SAThiel Air Care Inc · Chowchilla, CABuilt 1980 · S/N LJ918 N918VSDodson International Parts Inc · Rantoul, KSBuilt 1976 · S/N LW-200 N918XDos Hombres Ventures LLC · Wilmington, DEBuilt 1990 · S/N 560-0071 N918XZAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1990 · S/N 258177 N9192QMonroe Aviation Inc · Verona, PABuilt 1971 · S/N E-259 N9195QMeadowlake Airpark LLC · Lenoir City, TNBuilt 1971 · S/N TH-152 N919ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29520 N919BWIcm Inc · Colwich, KSS/N FL173 N919CAvventura Del Volo LLC · Nashville, TNBuilt 2004 · S/N E-3563 N919CAAc Spe 2 LLC · Orlando, FLBuilt 1991 · S/N 25302 N919DPTrumbull Thomas A Trustee · Leland, MIBuilt 1987 · S/N E-2373 N919DUDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 63531 N919HPKing Three LLC · Forest Hill, MDBuilt 1985 · S/N FA-81 N919JBWiz Air LLC · Wilmington, DEBuilt 1980 · S/N E-1702 N919MCHanson Operating Company Inc · Roswell, NMBuilt 2006 · S/N 525-0600 N919MSStraits Mark · Sugarcreek, OHS/N E-3504 N919MTTrue Drilling LLC · Casper, WYBuilt 2015 · S/N FL-1020 N919NNBank Of Utah Owner Trustee · Salt Lake City, UTBuilt 2013 · S/N 29573 N919RATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 30174 N919REIvy Brothers Aviation LLC · Kilgore, TXS/N BB824 N919WTAir Waukegan LLC · Waukegan, ILBuilt 2001 · S/N 313 N91ACTalkeetna Air Taxi Inc · Talkeetna, AKBuilt 2016 · S/N 208B5296 N91AP91ap LLC · Shreveport, LABuilt 1979 · S/N 501-0117 N91BBBunn Brothers Aviation LLC · Tuscaloosa, ALBuilt 2001 · S/N 525-0417 N91CLAircraft Structures International Corp · Enid, OKBuilt 1987 · S/N 208B0054 N91CTClemson University · Clemson, SCBuilt 1998 · S/N LJ-1521 N91CVTwin P Aviation LLC · Fort Worth, TXBuilt 1991 · S/N 5600009 N91GJGlobal Jetcare Inc · Brooksville, FLBuilt 1975 · S/N 032 N91HGMonson Creek Ranch Inc · Mobile, ALBuilt 1981 · S/N 501-0199 N91JRSpring Mountain Properties LLC · Fort Smith, ARBuilt 1973 · S/N TH-313 N91KABank Of Utah Trustee · Salt Lake City, UTS/N LJ-1232 N91KKState Of Florida · Tampa, FLBuilt 2022 · S/N 525-1119 N91MFCkw Aviation LLC · Dalhart, TXBuilt 1980 · S/N BB-657 N91PSCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1996 · S/N 258328 N91RBCitation Sky LLC · Moody, ALS/N 5250124 N91RWJujufa21 LLC · Wilmington, DEBuilt 1984 · S/N FA-21 N91TEGreene Charles M · Pompano Beach, FLBuilt 1981 · S/N 501-0173 N91WMN2sb LLC · Southlake, TXBuilt 1983 · S/N TH-1396 N9203QDavis & Automotive Services Inc · Carlinville, ILBuilt 1971 · S/N E-261 N920ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29521 N920DUBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 63533 N920EJAlliance Aviation Group LLC · Wilmington, DEBuilt 2005 · S/N 258705 N920FEFederal Express Corp · Memphis, TNS/N 208B0020 N920GCSabre Drilling Consulting LLC · Summerfield, NCBuilt 1992 · S/N TH-1660 N920LGSmart Motion Advisory Group LLC · Frisco, TXBuilt 1994 · S/N E-2901 N920MSale Reported · Homestead, FLSale reportedBuilt 1947 · S/N D-147 N920NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 31165 N920PTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1989 · S/N 560-0004 N920TCHendershot Aviation LLC · Houston, TXBuilt 1996 · S/N 258291 N920TTBank Of Utah Trustee · Salt Lake City, UTBuilt 1992 · S/N LJ-1300

Back to AD 2006-16-18 R1