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.

N437WFHewitson Enterprises Inc · Avenal, CABuilt 1981 · S/N BB-962 N438CRKilo Alpha 438 LLC · Edgewater, FLBuilt 1978 · S/N BB438 N438LADownstown Airport Inc · Vineland, NJBuilt 2014 · S/N 602-1238 N43BGRight Brothers LLC · San Clemente, CABuilt 1994 · S/N FL-117 N43CW42f LLC · Key West, FLBuilt 1990 · S/N 20800175 N43VMN43vm LLC · Fremont, CABuilt 2000 · S/N 46-97005 N43WAWhatever Aviation LLC · Olympia, WABuilt 1970 · S/N LJ-501 N43WHLaurel Malibu LLC · Windber, PABuilt 1982 · S/N 31T-8120068 N440CACc Flight Company LLC · Columbia City, INBuilt 1985 · S/N 42-5501027 N4415FB&G Air Inc · Morgan City, LABuilt 2002 · S/N LJ-1675 N442DSSantori Aviation LLC · Helena, MTBuilt 1994 · S/N 96 N442MAMeyers Air Service LLC · Superior, NEBuilt 2022 · S/N 602-1337 N444ASAas LLC · Ovid, MIBuilt 1982 · S/N 400-0438 N444CMDl Aviation Solutions LLC · Jacksonville, FLBuilt 1996 · S/N 152 N444FTOn The Horizon Aviation LLC · Tampa, FLBuilt 2000 · S/N 322 N444HFJohnson Airspray Inc · Argyle, MNBuilt 1992 · S/N T36-191 N444WGSchmucker Real Estate Holdings Lp · Wilmington, DEBuilt 1981 · S/N 31T-8166054 N445LLMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 2023 · S/N K045 N445MSAas LLC · Ovid, MIBuilt 1994 · S/N 502B-0237 N4476FTrans Executive Airlines Of Hawaii Inc · Honolulu, HIBuilt 1987 · S/N SH3731 N447DBGuardian Flight LLC · Lewisville, TXBuilt 2001 · S/N LJ-1656 N4488LSouth Texas Aviation Inc · Wilmington, DEBuilt 1995 · S/N LJ-1423 N448LAAir Kraft Spraying Inc · Timber Lake, SDBuilt 2012 · S/N 802A-0448 N449CACharlie Alpha LLC · Ketchum, IDBuilt 1999 · S/N 150 N44KAHunter Aviation Of Tampa LLC · Saint Petersburg, FLBuilt 2000 · S/N BB-1711 N45123Wood Flying Inc · Panhandle, TXS/N 402-0753 N4512JCentral Iowa Agricultural Aviation LLC · Wellsburg, IABuilt 2023 · S/N 602-1349 N4515JLowry Flying Service Inc · Grinnell, IABuilt 2024 · S/N 602-1380 N45196Boettcher Aerial Inc · Beloit, KSS/N 402-0755 N4523LWiebe Albert · Seminole, TXS/N 402-0757 N4527XSug-Air LLC · Lubbock, TXS/N 402A-0758 N4528LSkyworks Aviation LLC · Waynesboro, GAS/N 402A-0759 N452GHCrescent Real Estate Investors LLC · Park City, UTBuilt 2005 · S/N 628 N45363South Delta Aviation Inc · West Helena, ARS/N 402-0774 N45368Atlantic Ag Aviation Inc · Felton, DEBuilt 1990 · S/N 401-0775 N4539BWoodley Aerial Leasing LLC · Walnut, ILBuilt 1990 · S/N 401-0763 N4540FWoodley Aerial Leasing LLC · Walnut, ILBuilt 1990 · S/N 402-0784 N4540YTlc Flying Inc · Colfax, WABuilt 1990 · S/N 502-0120 N4541SKankakee Valley Aviation LLC · Wanatah, INS/N 402-0778 N45461Shannon Agricultural Flying Inc · Clarksdale, MSBuilt 1990 · S/N 502-0124 N45469Over & Under Flying Service Inc · Madison, INBuilt 1991 · S/N 402A-0797 N45472Rtc Aviation LLC · Munday, TXBuilt 1991 · S/N 402A-0794 N454CACul8tr LLC · Boynton Beach, FLBuilt 1982 · S/N 31T-8104053 N454LFJamm Aviation Inc · Columbus, OHBuilt 1998 · S/N FL-209 N454SFPa1 208b-0797 LLC · Fort Lauderdale, FLBuilt 1999 · S/N 208B-0797 N45506Mid Continent Aircraft Corp · Hayti, MOBuilt 1991 · S/N 502-0132 N4550NNewberg Sky Spray LLC · Hector, MNBuilt 1991 · S/N 502-0131 N4551MCady Leslie L · Rock Falls, ILBuilt 1991 · S/N 502-0133 N45553Racer Aviation LLC · Moorestown, NJBuilt 1991 · S/N 402-0818 N4555YDevil Dusters Inc · Artesia, NMBuilt 1991 · S/N 402-0812

Back to AD 2016-05-13