Registered aircraft · 3,126

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:2016-05-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-05-13') 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:2016-05-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-05-13')
  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:2016-05-13')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-05-13')
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.

N315WSAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1984 · S/N 425501015 N316LAAir Tractor Inc · Olney, TXBuilt 2026 · S/N 802A-1316 N316LVBayne Air LLC · Whitefish, MTBuilt 2025 · S/N K097 N316PDLonghorn Air LLC · Wilmington, DEBuilt 2003 · S/N 14038 N316PMAir Methods LLC · Greenwood Village, COBuilt 1998 · S/N 241 N316PWAl Force 1 LLC · North Salt Lake, UTBuilt 1991 · S/N FM2 N316WRHoxie Sprayers Inc · Hoxie, KSBuilt 1995 · S/N 502A-0316 N31941Gasper Air Spray Inc · Crookston, MNBuilt 1995 · S/N T45-008 N319EEReveille Aviation LLC · Kurten, TXBuilt 2004 · S/N FL-401 N319HCThree Flying Monkeys LLC · Sunray, TXBuilt 2017 · S/N 602-1286 N319PDOrtiz Luis Emerito Nieves · Plantersville, TXBuilt 2004 · S/N 14040 N319TBShuck Holdings LLC · Anderson, SCBuilt 2005 · S/N 319 N319WWWin Win Aviation Inc · Wake Forest, NCBuilt 1992 · S/N SH3209 N31TNLake Clark Air Inc · Port Alsworth, AKBuilt 1969 · S/N U49 N31WDWestern Dakota Holding Co · Timber Lake, SDBuilt 1980 · S/N 425-0012 N31XXTj Air Holdings Inc Trustee · Wilmington, DEBuilt 1990 · S/N FL-31 N3211RJohnson Airspray Inc · Argyle, MNBuilt 1978 · S/N 5100R N3216KSouth River Services LLC · Myrtle Beach, SCS/N LJ-1392 N321CWBatte Bennie S · Forest, MSBuilt 1999 · S/N 155 N321CYTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1968 · S/N 211 N321FDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1979 · S/N BC-70 N321HXGggg LLC · Hilton Head Island, SCBuilt 1981 · S/N 425-0104 N321PDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1980 · S/N GR-10 N3220LPee Dee Aviation LLC · Florence, SCBuilt 1995 · S/N LJ-1420 N3221MGuardian Flight LLC · Lewisville, TXBuilt 2000 · S/N LJ-1621 N322HGH & O Aviation LLC · Oxford, MSBuilt 1993 · S/N FL-93 N322MRPf Aircraft LLC · Graham, TXBuilt 2000 · S/N LJ-1611 N322MTSkyak LLC · Chanhassen, MNBuilt 2022 · S/N 4698237 N322WWWest Aviation LLC · Palm City, FLBuilt 2020 · S/N 4698133 N3246SInsync Investments LLC · Dover, DEBuilt 1999 · S/N LJ-1576 N324WRenshi LLC · Palm City, FLBuilt 2024 · S/N K059 N3250VK & J Air Services Ltd · Midland, TXFirst renewal noticeBuilt 1995 · S/N BB-1523 N325BGTurrell Flying Service Inc · Turrell, ARBuilt 2010 · S/N 602-1188 N325BMFarm Air Service Inc · Tallulah, LABuilt 2003 · S/N 802A-0144 N325PWWatson 321 Air LLC · Flower Mound, TXBuilt 2023 · S/N 4698273 N3262REaglemed LLC · Wichita, KSBuilt 1999 · S/N LJ-1562 N3263CEaglemed LLC · Wichita, KSBuilt 1996 · S/N LJ-1432 N3263NGuardian Flight LLC · Lewisville, TXBuilt 1999 · S/N LJ-1563 N326CAAlpine Aviation Inc · Provo, UTBuilt 1970 · S/N U-135 N326KWBering Air Inc · Nome, AKBuilt 1990 · S/N BB1360 N327BGGrimsley Aviation LLC · Dallas, TXBuilt 2001 · S/N 4697073 N327MJTour Aviation LLC · Naples, FLBuilt 2005 · S/N 1099 N327MZWdl/Oracle LLC · Tucson, AZBuilt 1998 · S/N 4636160 N327RHealth Care Capital Of North Carolina LLC · Atlanta, GABuilt 1999 · S/N FL-259 N327SFState Of Colorado · Lakewood, COBuilt 2003 · S/N 511 N32973Crop Jet Aviation LLC · Gooding, IDBuilt 1995 · S/N T45-009 N3299KJones Aviation Inc · Biggs, CABuilt 1996 · S/N T45-012 N3299PAir Care Leasing LLC · Lamar, COBuilt 1996 · S/N T42-213 N329ATAirtrex Registration Corp Trustee · Wichita, KSS/N FL-329 N329GSAugusta Aviation Inc · Hilton Head Island, SCBuilt 1992 · S/N LJ-1320

Back to AD 2016-05-13