OpenAirDocs.org
AD 99-05-13 R1 WD

Registered aircraft · 13,518

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-05-13-R1-WD')
    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-05-13-R1-WD')
  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.

N8211DNortheast Aeronautics LLC · Sussex, NJBuilt 1957 · S/N D-5301N8213DC A P Air Rescue Flyers Inc · Salinas, CABuilt 1957 · S/N D-5303N8214DStaudacher Mark W · Bay City, MIBuilt 1957 · S/N D-5308N8215DCronk Jerry L · Ontario, CABuilt 1957 · S/N D-5302N8215MJnk Equipment LLC · Deer Harbor, WABuilt 1993 · S/N EA-548N821GHN821gh LLC · Hudson Oaks, TXBuilt 1994 · S/N E-2871N821RNew Dakota Holdings LLC · Hillsboro, NDS/N D-6058N821VOldfield Corwyn D · Visalia, CABuilt 1977 · S/N E-1100N8220DRice Kenneth A · San Francisco, CAS/N D-5310N8220FCegnar Ron W · Lexington, KYBuilt 1991 · S/N CE-1581N8220MHampshire Aviation Inc Trustee · Wilmington, DEBuilt 1993 · S/N E-2795N8221DDavison Ralph R II · Ava, MOS/N D-5323N8223DN8223d Corp · Lemont, ILS/N D-5309N8224DShoemaker Floyd H III · Oneida, TNBuilt 1957 · S/N D-5316N8224JMassingill Lynn · Gatesville, TXBuilt 1991 · S/N CE-1594N8226EPasqualino Mark W · Ocala, FLS/N BG-379N8228EBrown Robert L · Clovis, CAS/N BG-383N8228ZSquare Cube Flying Inc · San Diego, CAS/N E-2800N8229DKnight Ronald L Trustee · Etna, CABuilt 1957 · S/N D-5327N822GSBall John E · Barboursville, WVBuilt 1973 · S/N TE-916N822KCLucky Fighter Aviation Services LLC · Lakeland, TNBuilt 1979 · S/N P-499N822PJNeary Michael John · Tuckerton, NJBuilt 1979 · S/N WA-47N822SRegistered aircraftBuilt 1964 · S/N D-7552N822TMarburger James H · Phoenix, AZBuilt 1973 · S/N D-9513N8230YVasel Randolph L · Greenville, ILBuilt 1991 · S/N CE-1601N8231LTamboer Leonard · Cave Creek, AZS/N CE-1604N8232DPagliari Emil R · Fort Walton Beach, FLBuilt 1957 · S/N D-5334N8232KSherman Mark D · Port Orange, FLBuilt 1991 · S/N CE-1605N8233DTangobravo Consulting LLC · Redlands, CAS/N D-5335N8233JMunstead Hollow Farm LLC · Downington, PAS/N CE-1528N8234MFontenot Shane B Dr · Jennings, LABuilt 1991 · S/N EA-520N8236DThompson Ronald L · Lemon Cove, CAS/N D-5341N8236ESpringdale Ventures LLC · Ocala, FLBuilt 1993 · S/N E-2779N8236UHarris Adam K · Shrewsbury, MABuilt 1991 · S/N E-2677N8237DPts Inc · Wichita, KSBuilt 1957 · S/N D-5342N8237JWilcox Christopher M · Jay, OKBuilt 1991 · S/N E-2670N823LAN907ds LLC · Palo Alto, CABuilt 1997 · S/N E-3129N823PCLester Jon M · Lancaster, OHBuilt 1987 · S/N CE-1161N823PPPsm Aviation LLC · Lewes, DEBuilt 1975 · S/N M-1650N823RBma Ventures LLC · Boca Raton, FLBuilt 1959 · S/N D-6049N823TKnight Koby Ernest · Haslet, TXS/N D-9521N823UWalkowicz Eddie F · Garland, TXFirst renewal noticeBuilt 1961 · S/N TC-45N823VUsher James C · Fort Worth, TXBuilt 1976 · S/N D-9872N8240TKolotushkin Igor · North Hills, CABuilt 1990 · S/N CE-1542N8241DMco Holdings LLC · De Pere, WIS/N D-5343N8241KBlytheair LLC · Laguna Hills, CABuilt 1991 · S/N CE-1616N8241NSpecial Services LLC · Magnolia, DEBuilt 1991 · S/N EA-522N8242JRegistered aircraftBuilt 1991 · S/N E-2676N8242TN8242t LLC · Phoenix, AZBuilt 1991 · S/N CE-1610N8243DMalkin John · Rockport, TXBuilt 1957 · S/N D-5345
Back to AD 99-05-13 R1 WD