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.

N527TBN527tb LLC · Missoula, MTBuilt 1998 · S/N 4636166N529LBAeronova LLC · Lexington, KYBuilt 2012 · S/N 4636544N529WMPc Aviation LLC · Kanarraville, UTBuilt 1999 · S/N 4636222N52WXGalaxy Drivers LLC · Dover, DEBuilt 1984 · S/N 468508011N530DCCrosswind Air LLC · Frederick, MDBuilt 2016 · S/N 4636690N530MARice Solutions LLC · Farmington, NHBuilt 2023 · S/N 4636817N5329F29foxtrot LLC · Wilmington, DES/N 4636316N53517Papadelta Inc Trustee · Wilmington, DEBuilt 2002 · S/N 4636330N536SBKilo One LLC · Saint Petersburg, FLBuilt 1996 · S/N 4636048N536TPDownhill Aero LLC · Kalispell, MTBuilt 1999 · S/N 4636212N545JWBlaise Alexander Management Inc · Muncy, PABuilt 1998 · S/N 4636146N545RSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 4636668N546CPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 4636879N54WTAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1999 · S/N 4636202N550CADubin Donald · Salida, COBuilt 2018 · S/N 4636736N550JKTaffet Jay · New Orleans, LABuilt 1986 · S/N 46-8608041N550MPPal Aviation LLC · Natchez, MSBuilt 1986 · S/N 4608041N555JVColumbia Recreation LLC · Quincy, WABuilt 2000 · S/N 4636270N555MBOpus Partners LLC · Orlando, FLBuilt 2018 · S/N 4636722N555PLQualitair LLC · MichelstadtBuilt 1988 · S/N 4608121N557MLAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1996 · S/N 4636064N558STNewport Federal · Newport Beach, CABuilt 2012 · S/N 4636558N55JSSky Kings 3 LLC · Irvine, CABuilt 2023 · S/N 4636821N55WHSvetair Inc Trustee · Wilmington, DEBuilt 1999 · S/N 4636204N560JPExecutive Aero Inc · Peyton, COBuilt 1995 · S/N 4622189N560MPJet Prop Aviation Inc · Phoenix, AZBuilt 1998 · S/N 4636171N561CGreene Michael E · Auburn, ALBuilt 2002 · S/N 4636326N565DELovestar Holdings LLC · Newark, DEBuilt 2012 · S/N 4636565N567KCWelch Darrnell M · Hillman, MIBuilt 1987 · S/N 4608071N569STSer Logistics LLC · Marietta, GABuilt 2020 · S/N 4636769N56CXThinair LLC · Dover, DEBuilt 2000 · S/N 4636279N56SASimply Mandys LLC · Reedley, CABuilt 2023 · S/N 4636828N571DRSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1996 · S/N 4636040N572PMHigh Desert Travel Inc · Scottsdale, AZBuilt 2013 · S/N 4636572N5757International Air Services Inc Trustee · Carson City, NVBuilt 1997 · S/N 4636114N575VNQualitair LLC Trustee · MichelstadtBuilt 1985 · S/N 468508057N57CXDmdt Ventures LLC · Victor, NYBuilt 1986 · S/N 46-8608013N581RVKurtz Andrew · Boise, IDBuilt 2011 · S/N 4636507N5829DCounty Of Henrico Va · Henrico, VABuilt 2018 · S/N 4636739N582ASChip Henry Aviation LLC · Bel Aire, KSBuilt 1996 · S/N 4636036N582MBLatitude Leasing LLC · Birmingham, ALBuilt 1999 · S/N 4636237N589EMalibu Leasing LLC · Broomfield, COS/N 46-8408046N58BCDkg LLC · Helena, MTBuilt 1989 · S/N 4622058N59019Kousa LLC · Mount Tabor, NJBuilt 1998 · S/N 4636148N590GStar 5 Airlines LLC · Houston, TXBuilt 2013 · S/N 4636611N595SMLapoint LLC · Holland, OHBuilt 1995 · S/N 4622185N595STHensley Auto Group Inc · Middletown, OHBuilt 2013 · S/N 4636595N596STIrish Flyboy LLC · Jackson, WYBuilt 2013 · S/N 4636596N597KCAlexis Aviation LLC · Montgomery, TXBuilt 2013 · S/N 4636597N59EMFletcher Marvin L · Fargo, NDBuilt 1984 · S/N 46-8508022
Back to AD 99-15-04 R1