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.

N549PNSouthern Airways Pacific LLC · Addison, TXBuilt 2013 · S/N 208B5049 N549PTGrant P T · Musella, GABuilt 1976 · S/N TH-711 N54CHLawsuit Air LLC · Onalaska, TXBuilt 1989 · S/N FA-188 N54CRCage Presnall C · Falfurrias, TXS/N 421C0812 N54CUN54cu Inc Trustee · Wilmington, DEBuilt 2022 · S/N 20800690 N54CYExtollo Aviation Partners LLC · Denver, COBuilt 2017 · S/N 525-0953 N54DAThoroughbred II LLC · State College, PABuilt 2001 · S/N 525-0470 N54DDChrysler Aviation Inc · Van Nuys, CABuilt 1990 · S/N 5600089 N54DGSaffron Aviation LLC · Carrollton, GABuilt 1979 · S/N E-1562 N54DRGarcia David D · Midlothian, TXS/N 94 N54HCThree Bears Aviation LLC · Prineville, ORBuilt 1996 · S/N 525-0157 N54JNDlz Aviation LLC · Ostrander, OHBuilt 1991 · S/N E-2684 N54MZFinch John Lambeth · Greensboro, NCBuilt 2023 · S/N 525-1154 N54NWAti Jet Sales West LLC · El Paso, TXBuilt 1982 · S/N 054 N54PAVpc Planes LLC · Wilmington, DEBuilt 1974 · S/N 004 N54PFSilverado Land Management LLC · Sparks, NVS/N E-2941 N54PTMccall Transport LLC · Portland, ORS/N LW-331 N54TKDlp Real Estate Capital Inc · Saint Augustine, FLBuilt 1980 · S/N BB-686 N54TPTsc N94pl LLC · Wichita Falls, TXS/N 5600160 N54TTRedcell Air Inc · Miami, FLBuilt 1981 · S/N 421C1054 N54USSilver Eagle Express LLC · Orange, CABuilt 1981 · S/N BE122 N54YPPhifer Inc · Tuscaloosa, ALBuilt 2003 · S/N 333 N55Textron Aviation Inc · Wichita, KSS/N FL-1388 N550AJCola Express LLC · Ripley, WVBuilt 1987 · S/N S550-0141 N550CZMldg Aviation LLC · Warden, WABuilt 1987 · S/N S550-0128 N550DCM A / F H Aviation Inc · Dayton, OHBuilt 1992 · S/N 560-0198 N550DLMmch Aerospace LLC · Goshen, INBuilt 1988 · S/N S550-0155 N550DSMetro Aviation Inc · Shreveport, LABuilt 1988 · S/N S550-0154 N550GBCordobesa Aviation LLC · Belgrade, MTBuilt 1977 · S/N 501-0054 N550GLGaba Zero Seven LLC · Beaumont, TXBuilt 1980 · S/N BB-781 N550HCVasquez Jimmy · Carlsbad, NMBuilt 1986 · S/N S550-0116 N550JFTs Aviation LLC · New York, NYBuilt 1985 · S/N 472 N550LPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2021 · S/N 208B5658 N550RJHovermale Ken · Portland, MEBuilt 1989 · S/N E-2516 N550SGNunya LLC · Irvine, CABuilt 1985 · S/N S550-0070 N550SPBh Sabbah LLC · Visalia, CABuilt 1997 · S/N BB-1572 N550TCContinental Jet LLC · Vero Beach, FLS/N 034 N550WDWoodbine Aviation LLC · Lewes, DEBuilt 1986 · S/N S550-0110 N550WEInformation Alpha LLC · St Thomas, VIBuilt 1988 · S/N S5500148 N550WKLegacy Jets LLC · Francesville, INBuilt 1985 · S/N S550-0029 N550WMWno Trust Services LLC Trustee · Wilmington, DEBuilt 1992 · S/N 229 N5512BAircraft Structures International Corp · Enid, OKBuilt 1992 · S/N 208B0299 N5519UBurlington Veterinary Systems LLC · Burlington, KSBuilt 1990 · S/N E-2519 N551ASAlaska Airlines Inc · Seattle, WABuilt 2006 · S/N 34593 N551CNChoctaw Nation Of Oklahoma · Durant, OKBuilt 1993 · S/N LJ-1347 N551DBKirby Ramsey Aviation Group LLC · Almont, COBuilt 1998 · S/N E-3158 N551FPSkyway Aviation Services Inc · Palm Harbor, FLBuilt 2003 · S/N 525-0515 N551GENw Miles Air LLC · Tualatin, ORBuilt 1980 · S/N 551-0181 N551GFJ M Malone & Son Inc · Carlisle, ARBuilt 1981 · S/N 551-0039 N551HHGem Air LLC · Bakersfield, CABuilt 1978 · S/N 551-0071

Back to AD 2006-16-18 R1