OpenAirDocs.org
AD 99-15-04 R1

Registered aircraft · 896

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
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:99-15-04-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:99-15-04-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.

N37RTPlane Fun Inc Tr Trustee · Snellville, GABuilt 1997 · S/N 4636082N37VMVictory Maximus LLC · Dublin, OHBuilt 1984 · S/N 46-8508002N383SA86 Malibu LLC · Fort Worth, TXBuilt 1986 · S/N 4608033N385RAdvanced Technology Distributors Inc · Ceres, CABuilt 1985 · S/N 46-8508038N386STWwc Sky Holdings LLC · Wilmington, DEBuilt 2025 · S/N 4636868N389AJAloe Jaumave USA LLC · Mcallen, TXBuilt 2025 · S/N 4636861N389PCN1543t LLC · Buffalo, NYBuilt 2010 · S/N 4636482N389STSouthgroup Aviation LLC · Oxford, MSBuilt 2006 · S/N 4636389N3935YShewchuk Bailey · KelownaBuilt 2014 · S/N 4636620N3946MPlane Flt LLC · Broken Arrow, OKBuilt 2014 · S/N 4636621N394MMN654nm LLC · Centreville, VABuilt 2010 · S/N 4636518N395PMBare Bones Aircraft Inc · Fort Walton Beach, FLBuilt 1995 · S/N 4622195N3975CMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 2007 · S/N 4636419N397PMAircraft 445 LLC · Porterville, CABuilt 1997 · S/N 4636113N398PMN398pm LLC · Atlanta, GABuilt 1998 · S/N 4636145N398WFOn Demand Aviation LLC · Port Orange, FLBuilt 2018 · S/N 4636734N39JEDuxbury Piper LLC · Duxbury, MABuilt 2010 · S/N 4636479N400TWJordy Sky Leasing LLC · Middletown, DEBuilt 1995 · S/N 4636015N402KCLazer Enterprises Ltd · Fargo, NDBuilt 2007 · S/N 4636420N405KCS H S Corporation · Indianola, IABuilt 1984 · S/N 46-8408044N408CAndonie Lourdes C · Mcallen, TXFirst renewal noticeBuilt 2006 · S/N 4636405N409CPHornowski Consulting Inc · Asheville, NCBuilt 2006 · S/N 4636375N40HPRock Communications LLC · Rock Hill, SCBuilt 2000 · S/N 4636264N40PMFlypie Industries LLC · Hudson, WIBuilt 1986 · S/N 4608005N40RZTwin Trails LLC · Draper, UTBuilt 1995 · S/N 4636009N410JCFbn Holding Corp · Larkspur, CABuilt 1986 · S/N 4608038N410STValiair Lc Trustee · Casper, WYBuilt 2007 · S/N 4636410N411MDJdr Inc · Cullman, ALBuilt 2000 · S/N 4636262N4121KMalibu Air LLC · Wilmington, DEBuilt 1998 · S/N 4636140N4133GAmsg Transport LLC · Bloomfield Hills, MIBuilt 1998 · S/N 4636186N4139TMalibu Mirage Inc · Eugene, ORFirst renewal noticeBuilt 1998 · S/N 4636179N4141GPon Douglas James · Chalfont, PABuilt 1999 · S/N 4636233N41484Ferraro Jeffrey T · Mckinney, TXBuilt 1999 · S/N 4636234N4149RClary Daniela · Sunnyvale, TXBuilt 1999 · S/N 4636226N41518Lechene Craig · Holly Springs, NCBuilt 2000 · S/N 46-36302N4152DSires Brian · Cedar Falls, IABuilt 2000 · S/N 46-36304N41599Tiger Helicopters LLC · Baton Rouge, LABuilt 1999 · S/N 4636187N415DJAms Enterprises Capital Holdings Inc · Newark, DEBuilt 2016 · S/N 4636710N415VAVel-Air Inc · Clifton, VABuilt 2000 · S/N 4636290N415WRN415wr LLC · Bogart, GAS/N 4636147N415X3 Axis Aviation Inc Trustee · Wilmington, DEBuilt 2007 · S/N 4636425N4160NSteele Howard Scott · Idaho Falls, IDBuilt 2000 · S/N 4636280N4163PMalibu Aviation LLC · Bloomfield Hills, MIBuilt 2000 · S/N 4636274N41676American Roadways LLC · Missoula, MTBuilt 2000 · S/N 4636268N4167AWilliams Mirage LLC · Denver, COBuilt 2000 · S/N 46-36254N4167CSsp Aviation LLC · Aurora, OHBuilt 1999 · S/N 4636201N4175KYu Christopher · Menlo Park, CABuilt 2000 · S/N 4636294N41799Registration Pending · Panama City Beach, FLRegistration pendingBuilt 2000 · S/N 4636257N417JSCockapoo Air LLC · Naperville, ILBuilt 1998 · S/N 4636183N417MAT&G Aviation Services LLC · Temple, TXBuilt 2007 · S/N 4636415
Back to AD 99-15-04 R1