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.

N162SAJoby Aero Inc · Santa Cruz, CABuilt 1996 · S/N 208B0548 N162STState Of Michigan · Lansing, MIBuilt 1978 · S/N LW-300 N162UPUnited Parcel Service Co · Louisville, KYBuilt 2005 · S/N 0851 N1635WTullos Hugh S III · Oklahoma City, OKBuilt 1972 · S/N E-350 N163BALbk Air LLC · Newark, DEBuilt 1984 · S/N FA-18 N163JN163j LLC · Smithfield, NCBuilt 1987 · S/N S550-0122 N163JMGainesville Aircraft Sales Inc · Gainesville, FLBuilt 1988 · S/N 650-0163 N163PAN163pa LLC · Wilmington, DEBuilt 1982 · S/N 249 N163TSHemisphere Aerospace Investments LLC · Waco, TXS/N 34948 N163UHarbaugh Steven K · Austin, TXBuilt 1968 · S/N E-98 N163UPUnited Parcel Service Co · Louisville, KYBuilt 2005 · S/N 0852 N1648WKings Aviation Corp · Garden City, NYBuilt 1972 · S/N TH-251 N164RAJetway N164 LLC · Brooklyn, OHBuilt 2007 · S/N 560-0766 N164TSBank Of Utah Trustee · Salt Lake City, UTS/N 21119 N164UPUnited Parcel Service Co · Louisville, KYBuilt 2005 · S/N 0853 N164WSBank Of Utah Trustee · Salt Lake City, UTS/N LJ-1736 N1650WGriffin Michael D · Madison, ALBuilt 1972 · S/N E-352 N1655MMichigan Aeronautics Commission · Lansing, MIBuilt 1999 · S/N BB-1655 N165HPKessler William A Jr · Uvalde, TXBuilt 1981 · S/N E-1856 N165JVHigh Desert Aviation And Aerobatics LLC · Pocatello, IDBuilt 1998 · S/N E-3180 N165TGAmj Aviation LLC · Oneida, TNBuilt 1997 · S/N FL-165 N165TSBank Of Utah Trustee · Salt Lake City, UTS/N 21523 N165UPUnited Parcel Service Co · Louisville, KYBuilt 2005 · S/N 0854 N165YVAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-165 N166BASmith Joshua B · Kenai, AKBuilt 1988 · S/N FA-147 N166BVSensing Aviation LLC · Nashville, TNBuilt 2000 · S/N TH-1958 N166CLKa Partners LLC · Thomson, GABuilt 2000 · S/N FL-298 N166FAN166fa Aircraft Services LLC · Phoenix, AZBuilt 1980 · S/N 501-0166 N166RLLm Aeropsace Corp · Deerfield Beach, FLBuilt 1990 · S/N 047 N166SAClear Skies Ltd · Cincinnati, OHBuilt 1988 · S/N FA-166 N166STGable S Corp · West Linn, ORBuilt 2002 · S/N 560-0606 N166UPUnited Parcel Service Co · Louisville, KYBuilt 2005 · S/N 0861 N16701United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28762 N16703United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28764 N16709United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28779 N16713United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28784 N16732United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28948 N1673THarvey Alan G · Dallas, TXBuilt 1981 · S/N E-1895 N1673WOci Ltd · Brunswick, GABuilt 1972 · S/N TH-258 N167BBCentral Virginia Aviation Inc · Petersburg, VABuilt 1983 · S/N LJ-1054 N167LHIntercontinental Commercial Aircraft Inc · Morriston, FLNon-citizen corporation, flight hours not reportedS/N 208B1162 N167SCSage Creek Aviation LLC · American Canyon, CABuilt 2005 · S/N 258742 N167TRBarton Aviation LLC · San Antonio, TXBuilt 1998 · S/N TH-1849 N167UPUnited Parcel Service Co · Louisville, KYBuilt 2005 · S/N 0862 N167WCWashington Corporations Inc DBA · Missoula, MTS/N 343 N1685SBella Vista Transportation & Rentals LLC · Dunnellon, FLS/N LJ-1685 N1687WAirway Management Inc · Wilmington, DEBuilt 1972 · S/N E-355 N168BGValle Aviation Inc · Nashville, GABuilt 1995 · S/N 5600301 N168CCLanham Aviation LLC · Simpsonville, KYBuilt 1990 · S/N TH-1606 N168JGFlymore LLC · New City, NYBuilt 1999 · S/N E-3253

Back to AD 2006-16-18 R1