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.

N46LYRossi Carl J Jr · Florence, ORBuilt 2021 · S/N 4636778N46MBAig Aeronautics LLC · Guaynabo, PRBuilt 1984 · S/N 46-8508021N46MGHughes Shaun · Everett, WABuilt 1988 · S/N 4608136N46PAAyer William S · Bellevue, WABuilt 1984 · S/N 46-8408060N46PMMcmillan Michael J · Forsyth, GABuilt 1989 · S/N 4622081N46PTT & K LLC · Bloomington, ILBuilt 1990 · S/N 4622108N46PWSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2005 · S/N 4636370N46SEAddie-Air Inc · Bridgeport, TXBuilt 1992 · S/N 4622131N46TDRockstar Air LLC · Mcgregor, TXBuilt 1998 · S/N 4636177N46UPalmy LLC · Lander, WYBuilt 1987 · S/N 4608072N46WHAbecca Corp · Jackson, MIBuilt 1993 · S/N 4622141N477TWMalibu Aircraft LLC · Scottsdale, AZS/N 4636477N47BCBrentech Leasing LLC · Cartersville, GABuilt 1988 · S/N 4608129N47DWN47dw LLC · Camden, DES/N 4636763N47ER15 East Management Inc · Wake Forest, NCBuilt 2002 · S/N 4636340N480CATyne Aviation LLC · Nashville, TNBuilt 2007 · S/N 4636414N480RVLizfly LLC · Butler, PABuilt 2000 · S/N 46-36269N48HCMirage Flight LLC · Kalispell, MTS/N 4636377N495MAZero G Aviation LLC · Helena, MTBuilt 2010 · S/N 4636484N495PMDmfs Leasing LLC · Des Moines, IABuilt 2025 · S/N 4636871N497MAAlexandria Spine & Rehab Center LLC · Alexandria, LAS/N 4636498N497MSN497ms LLC · Miami, FLBuilt 2015 · S/N 4636678N498MMLadd Air LLC · Mt Holly, NCS/N 4636149N49HFStanley Jason · Georgetown, TXBuilt 1988 · S/N 46-08125N49PKMalibu Associates Inc · Frederick, MDBuilt 1989 · S/N 4622050N49XLQualitair LLC Trustee · MichelstadtBuilt 1989 · S/N 4622049N4DWFlycone LLC · Encinitas, CABuilt 2025 · S/N 4636864N500DYEnterprise Aircraft Finance LLC · Clayton, MOBuilt 2025 · S/N 4636865N500NMGriffin Medical LLC · Sidney, NEBuilt 2011 · S/N 4636500N502EUMirage N502eu LLC · Benton Harbor, MIBuilt 1995 · S/N 4622182N50BFStephenson Keith · Studio City, CABuilt 2004 · S/N 4636355N510KCProcoff LLC · Shreveport, LABuilt 1993 · S/N 4622151N512TNexus Air LLC · Williston, NDBuilt 2012 · S/N 4636532N515DM618 Aircraft LLC · Louisville, ILBuilt 2016 · S/N 4636709N515RRHangar 49 Ltd · Wilmington, DEBuilt 1987 · S/N 4608080N515TATomcat Aviation Inc · Tallahassee, FLBuilt 2003 · S/N 4636347N516AGF & A Enterprises LLC · Houston, TXBuilt 2008 · S/N 4636446N516DLKey Air Service LLC · Peyton, COBuilt 2011 · S/N 4636506N516RSGenesee Air LLC · Wilmington, DEBuilt 1999 · S/N 4636208N518C30air LLC · Camden, DEBuilt 2008 · S/N 4636449N518GERichtair LLC · Alpharetta, GABuilt 2023 · S/N 4636818N519DMSingh Aviation LLC · San Antonio, TXBuilt 2012 · S/N 4636528N519WRTsmhta LLC · Indianapolis, INBuilt 2000 · S/N 4636259N51BKBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 4636566N521MGHlma LLC · Waverly, WVBuilt 2015 · S/N 4636663N521MMEagle Topflight LLC · Cape Girardeau, MOBuilt 1988 · S/N 4608104N522MKTurbines Ltd · West Point, NEBuilt 2000 · S/N 4636284N522PMRegistration Pending · Castle Rock, CORegistration pendingS/N 4636568N523MLForster David · Friendswood, TXBuilt 1989 · S/N 4622087N526JMFaith-Full Family Finances Inc · Mount Vernon, OHBuilt 1994 · S/N 4622166
Back to AD 99-15-04 R1