Registered aircraft · 11,797

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.

N14HHDelaware Professional Aviation LLC · Dalton, GABuilt 1988 · S/N BB-1286 N14JHRegistered aircraftBuilt 1998 · S/N TH-1845 N14LRGolly Laura · Deridder, LABuilt 1974 · S/N E-524 N14MBJackson Craig D · Idaho Falls, IDBuilt 1977 · S/N E-1062 N14MNOne Room LLC · Abilene, TXBuilt 1978 · S/N E-1344 N14NGFirst Avenue Management LLC · Savannah, GABuilt 1987 · S/N BB-1276 N14NMDriscoll Health Care Services · Corpus Christi, TXBuilt 1973 · S/N LW-35 N14PBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 258317 N14RFBerry Darrel · Camden, TNBuilt 1973 · S/N E-486 N14RM29foxtrot LLC · Wilmington, DEBuilt 1980 · S/N 551-0169 N14SBMountain Air Aviation LLC · Jonesville, VAS/N LW-214 N14VAAerospace Asset Holdings LLC · Wilmington, DEBuilt 1979 · S/N 501-0137 N14WWWa Consulting LLC · Nashville, TNS/N E-3297 N14XMMedical Diagnostic Imaging Inc · Sacramento, CABuilt 1976 · S/N TH-758 N150CNKing Air Investments LLC · Ferriday, LABuilt 1981 · S/N LA-138 N150EXDodson International Parts Inc · Rantoul, KSS/N 262 N150GPSteel Aircraft Leasing LLC · Saint Augustine, FLFirst renewal noticeS/N 560-0127 N150GWRocinante Air LLC · Cincinnati, OHBuilt 1998 · S/N LJ-1531 N150GXWest Penn Aviation LLC · Midland, TXBuilt 2008 · S/N FL592 N150JMPog Capital LLC · Wilmington, DEBuilt 1998 · S/N 258382 N150RFR & F Wings III LLC · Liverpool, NYBuilt 2015 · S/N FL-1023 N150RJ513 LLC · Newark, DEBuilt 2002 · S/N 324 N150RMBurke Aviation LLC · Toomsuba, MSBuilt 1978 · S/N 501-0076 N150SBRegistration Pending · Anchorage, AKRegistration pendingBuilt 1991 · S/N 258197 N150SSSweetener Supply Corp · Brookfield, ILBuilt 1987 · S/N 213 N150TWCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1973 · S/N LW-50 N150UPUnited Parcel Service Co · Louisville, KYBuilt 2003 · S/N 833 N150VECarnes 150ve LLC · Wichita Falls, TXBuilt 1975 · S/N LJ-678 N150YDSfh Inc DBA · Fargo, NDBuilt 1997 · S/N BB-1561 N1511WFlorida Float Plane LLC · Coral Gables, FLBuilt 1972 · S/N TH-217 N1515WCenturionair LLC · Greenville, SCBuilt 1972 · S/N TH-218 N1516MWrubel David · Atlanta, GABuilt 1988 · S/N E-2459 N15186N15186 LLC · Dyer, INBuilt 1988 · S/N E-2456 N151CLAircraft Structures International Corp · Enid, OKBuilt 1988 · S/N 208B0083 N151ELCarolina Turbine Sales Inc · Raleigh, NCBuilt 1978 · S/N BB-371 N151SPLux Leasing LLC · Shreveport, LABuilt 1977 · S/N 501-0021 N151UPUnited Parcel Service Co · Louisville, KYBuilt 2003 · S/N 834 N151WTKo Aviation LLC · Wilmington, DEBuilt 1983 · S/N BB-1151 N1522LGoetz Dennis D · Mason, OHBuilt 1988 · S/N E-2457 N1525WClark Josh D · Morehead, KYBuilt 1972 · S/N E-324 N1526MGarmin At Inc · Salem, ORBuilt 1994 · S/N TH-1711 N15278Zastrow Lyn · Prosper, TXBuilt 1990 · S/N E-2550 N1528KBuck Daniel · Ashland, VABuilt 1988 · S/N E-2453 N152JHSeaport Aviation Inc · Quincy, MABuilt 2002 · S/N 560-0615 N152KWestern Capital Partners LLC · Wilmington, DEBuilt 1962 · S/N 500A-1258-82 N152KVPlane House LLC · Indianapolis, INBuilt 1996 · S/N 525-0152 N152TATuck Aerial Surveys Inc · Big Stone Gap, VAS/N 20800664 N152UPUnited Parcel Service Co · Louisville, KYBuilt 2003 · S/N 835 N152WLHeart One LLC · Little Rock, ARBuilt 1977 · S/N BB-260 N152WWNardi Greg · Missoula, MTS/N LJ-654

Back to AD 2006-16-18 R1