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

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

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.

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

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.

N200JEBloch Gregory S · Xenia, OHBuilt 2011 · S/N 4636501 N200JPBlacklist LLC · Lake Norden, SDBuilt 2014 · S/N 4636649 N200WWRoark LLC · Bend, ORBuilt 1985 · S/N 46-8508035 N201GWInternational Air Services Inc Trustee · Carson City, NVBuilt 1985 · S/N 468508055 N203CAStrasbaugh Development Corp · San Luis Obispo, CABuilt 1997 · S/N 4636102 N205APPappalardo Anthony · Vero Beach, FLBuilt 2000 · S/N 46-36250 N20DPErvin Eric · La Follette, TNBuilt 1988 · S/N 4608140 N20PTN20pt LLC · Wilmington, DEBuilt 2020 · S/N 4636771 N2119JFour Corners Air Transit Service LLC · Aztec, NMBuilt 2010 · S/N 4636488 N211MAFlames Ltd Trustee · Wilmington, DEBuilt 2012 · S/N 4636546 N212KMMollet Kern · Massillon, OHBuilt 1996 · S/N 4636052 N2138CAv Holding Co LLC · Polson, MTBuilt 1986 · S/N 46-8608020 N213JPEducators Aviation LLC · Wilmington, DEBuilt 1986 · S/N 4608030 N213PMLbair LLC · Hackensack, NJBuilt 2014 · S/N 4636622 N217TSLaukatel Air Inc Trustee · Wilmington, DEBuilt 1998 · S/N 4636144 N219DL3 Wolfpack Sigma LLC · Overland Park, KSBuilt 1999 · S/N 4636209 N21AGGronemeyer Jens · Deland, FLS/N 4636106 N220WJaw Air LLC · Fargo, NDS/N 4622052 N221PPLive Pilot Training LLC · Ankeny, IABuilt 1987 · S/N 46-08064 N221STForza Management Co · Auburn, MABuilt 2014 · S/N 4636651 N221TBSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1985 · S/N 46-8508061 N222FS404 Church LLC · Wayne, PABuilt 2022 · S/N 4636810 N222ZMPresentation Impact LLC · Sandia Park, NMBuilt 1990 · S/N 4622115 N224JJCox Gerald Lee · Shepherdsville, KYBuilt 1994 · S/N 4622155 N225MCP46 Tango LLC · Friday Harbor, WABuilt 1999 · S/N 4636239 N227WDPowell David C · Ingram, TXBuilt 1990 · S/N 4622097 N229MAN&D Executive Services LLC · San Antonio, TXS/N 4636129 N22CXMount Vernon Air LLC · Ewing, ILS/N 4622066 N22FXWoodland Aviation LLC · Belmont, MIBuilt 1985 · S/N 46-8508043 N22MVJm Aviation Holdings LLC · Loudonville, NYBuilt 2024 · S/N 4636843 N22SYSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1997 · S/N 4636122 N2313QRegistered aircraftBuilt 2010 · S/N 4636474 N2316XJnj Aviation Inc · Wilmington, DEBuilt 2010 · S/N 4636487 N2325JLesterville Land Holdings LLC · Ellington, MOBuilt 2010 · S/N 4636480 N234AGLop LLC · Orangeburg, SCBuilt 2011 · S/N 4636510 N2365SIe3 Enterprise LLC · Elk Grove, CABuilt 2011 · S/N 4636490 N2369AValiair Lc Trustee · Casper, WYBuilt 2024 · S/N 4636851 N237CLnh Holdings LLC · Richardson, TXBuilt 2013 · S/N 4636610 N237MAR E Dimond And Associates Inc · Indianapolis, INBuilt 2013 · S/N 4636587 N23DKStockwell Aviation LLC · Clarence Center, NYBuilt 2018 · S/N 4636721 N2413ACotner Jeffry J · Houston, TXBuilt 2011 · S/N 4636496 N241DGJust Plane Fun · Santa Barbara, CABuilt 2010 · S/N 4636489 N242MJWch/Lgs Sky Ventures LLC · Littleton, NCS/N 4636674 N242WFN242wf LLC · Wilmington, DEBuilt 2012 · S/N 4636571 N244LMSunset Horizons LLC · Clovis, CABuilt 2012 · S/N 4636531 N245EABlue Heron Aviation LLC · Port Orange, FLBuilt 2021 · S/N 4636777 N245SSharpaire LLC · Wilmington, DEBuilt 1997 · S/N 4636104 N246LRegistered aircraftBuilt 2023 · S/N 4636825 N249FBK4m Aviation LLC · Marksville, LABuilt 1999 · S/N 4636221 N250BTHeart Gate Enterprises LLC · Pittsburgh, PABuilt 2002 · S/N 4636334

Back to AD 99-15-04 R1