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.

N350SNMarco Aviation Services Inc · Neosho, MOBuilt 2015 · S/N 4636683 N350TVCloverfield Aero LLC · Los Angeles, CABuilt 2015 · S/N 4636672 N350TZMangione Thomas J · Kamas, UTBuilt 2019 · S/N 4636750 N350USkyrocket Property LLC · Harlingen, TXBuilt 2026 · S/N 4636874 N350VBPip 350 Mt L.C. · Darby, MTBuilt 2015 · S/N 4636675 N350VTCope Daniel Patrick · New York, NYBuilt 2016 · S/N 4636693 N350WN350w LLC · Jenks, OKBuilt 2020 · S/N 4636765 N350WDLillyair LLC · Naples, FLBuilt 2016 · S/N 4636703 N350WLJal Equipment LLC · Houston, TXBuilt 2019 · S/N 4636753 N350WMBank Of Utah Trustee · Salt Lake City, UTBuilt 2024 · S/N 4636839 N350WTM & M Gosch LLC · Temecula, CABuilt 2020 · S/N 4636767 N350XCK & W Holdings Inc · Port Orange, FLBuilt 2016 · S/N 4636704 N350XLN350xl Inc Trustee · Wilmington, DEBuilt 2015 · S/N 4636673 N350XPChristenson Advisory Team LLC · Great Falls, VABuilt 2015 · S/N 4636652 N350XSSchoenig Joe · Alto, NMBuilt 2016 · S/N 4636705 N350XTCentury Skyhawk Inc Trustee · Wilmington, DEBuilt 2016 · S/N 4636692 N351PMValiair Limited Company Trustee · Casper, WYBuilt 2024 · S/N 4636840 N351WTFree Bird Air LLC · Raymond, NEBuilt 1996 · S/N 4636071 N352CMSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1995 · S/N 4636019 N352HAIcs Air LLC · Saint James, MNS/N 46-8608034 N354RVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 4636537 N355CVertx Fleet Holdings LLC · San Diego, CABuilt 2018 · S/N 4636723 N355DCRyan John T · Salina, KSBuilt 1984 · S/N 46-8408079 N357CSN357c5 LLC · Clinton, MOBuilt 1984 · S/N 46-8508026 N357MMClark Melvin G · Sunnyvale, TXBuilt 1985 · S/N 46-8508092 N358WAWestern Aircraft Inc · Boise, IDBuilt 2025 · S/N 4636869 N359STN921rt LLC · Lithia, FLBuilt 2025 · S/N 4636859 N359VMAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 2015 · S/N 4636679 N35CMHorseshoe Air LLC · Fairfield, TXBuilt 2016 · S/N 4636708 N35GGWilforge LLC · Phoenix, AZBuilt 1999 · S/N 4636207 N35GHPiper Aircraft Inc · Vero Beach, FLS/N 4636880 N35KLR Ken Lord Md Pc · St George, UTBuilt 2022 · S/N 4636808 N362MAPiper Aircraft Inc · Vero Beach, FLBuilt 1996 · S/N 4636062 N363MMChicola Monty · Alexandria, LAS/N 4622007 N364STFlight Following LLC · Fayetteville, GABuilt 2005 · S/N 4636364 N369STAero-Mobil Inc · Wilmington, DEBuilt 2006 · S/N 4636396 N36CCjd Aviation LLC · Essex, CTBuilt 2018 · S/N 4636730 N36CBAopak Inc Trustee · Wilmington, DEBuilt 1983 · S/N 46-8408006 N36RECiconia Aeronautics LLC · Madison, MSBuilt 2013 · S/N 4636573 N372DGWild Air LLC · Exeter, CABuilt 2005 · S/N 4636372 N3737Qualitair LLC · MichelstadtBuilt 1985 · S/N 468508060 N374KCHostetter Swinea Aviation LLC · Dickson, TNBuilt 2005 · S/N 4636374 N374WFT2 Aviation LLC · Pahrump, NVBuilt 2012 · S/N 4636527 N377HCHigh Altitude Aviation LLC · High Point, NCBuilt 2002 · S/N 4636332 N377STNewman Aviation Services Inc · Tiffin, OHBuilt 2018 · S/N 4636737 N378NSHinshaw Jerrold T · Baltimore, MDBuilt 1999 · S/N 4636236 N379PVisionary Holdings LLC · Missoula, MTBuilt 2006 · S/N 4636379 N37BEZortair LLC · Austin, TXS/N 4636761 N37DAW & S Aviation LLC · Pikeville, KYBuilt 2013 · S/N 4636574 N37PMRegistered aircraftBuilt 1985 · S/N 46-8508058

Back to AD 99-15-04 R1