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.

N627AJJorfam Properties LLC · Dripping Springs, TXBuilt 1974 · S/N D-9583N627BWoods William E · Phoenix, AZBuilt 1961 · S/N D-6767N627BMGist Brett · Poolville, TXBuilt 1962 · S/N DH-322N627DHottle Marlin DBA · Chambersburg, PAS/N D-2888N627KCHorsehead LLC · Ada, MIBuilt 1990 · S/N CE-1480N627LBJk Air LLC · Tupelo, MSBuilt 1980 · S/N TC-2303N627Q4s Technologies Inc · Beaver Dams, NYBuilt 1958 · S/N D-5627N627TBobo Kenneth O · Auburndale, FLBuilt 1958 · S/N D-5747N6280UBmk Farms · Fowler, KSBuilt 1982 · S/N TC-2439N62819Flying Monkey LLC · Pinckney, MIBuilt 1982 · S/N MC-772N6282VBautista Lance C · Modesto, CABuilt 1967 · S/N TE-463N6283GBoehler Michael J · Sharon Springs, NYFirst renewal noticeBuilt 1982 · S/N M-2353N6283NValiair Lc Trustee · Casper, WYBuilt 1982 · S/N E-2002N6284UBonanza Group LLC · Phoenix, AZBuilt 1982 · S/N E-2003N6284VBradsher Harold Michael · Troy, MOBuilt 1967 · S/N D-8605N62854High Flight Connections LLC · Roanoke, INBuilt 1982 · S/N E-2008N6285NMoon Dipper Aviation LLC · Deerfield Beach, FLBuilt 1982 · S/N E-2005N6285XSpires William A · Columbus, GABuilt 1982 · S/N E-2006N62874Arneson David Rolf · Montevideo, MNBuilt 1982 · S/N M2354N6287VGilbert Gavin J · Granbury, TXBuilt 1967 · S/N D-8607N6288VJaysix LLC · Greeley, COBuilt 1967 · S/N TE-459N628DMoler Alan D · Valley Center, KSBuilt 1951 · S/N D-2889N628QMcconville Aero LLC · Westminster, MDBuilt 1977 · S/N TC-2052N628SECane John Paul · San Jose, CABuilt 2000 · S/N EA-655N628TStaggs Steven C · Rockwall, TXBuilt 1958 · S/N D-5751N628ZGlantz Richard L · Whitefish, MTBuilt 1956 · S/N DH-123N6292ZBlv Aviation LLC · Columbus, INBuilt 1982 · S/N E-2010N62936Prop And Jet Air Museum · Romoland, CAS/N CA38N62954Big Bend Community College · Moses Lake, WABuilt 1982 · S/N M-2355N6296VFollis Chad · Hartford, IABuilt 1967 · S/N D-8621N6297LMccaskill Justin E · Montgomery, TXBuilt 1982 · S/N E-2012N6298URed Roadrunner LLC · Richmond, KYBuilt 1982 · S/N CE-995N6298VRegistered aircraftBuilt 1967 · S/N D-8611N6298XN111es Inc · Monticello, INS/N E-2013N6299XSouth Florida Exotics LLC · Missoula, MTBuilt 1982 · S/N E-2016N629BEWbme LLC · Warrenville, SCBuilt 1999 · S/N E-3287N629EBRuff Cattle Co · Hanston, KSBuilt 1997 · S/N E-3085N629PGOrial Floyd · Evans, GABuilt 2004 · S/N E-3550N629QSpeedyvee LLC · Nathrop, COBuilt 1959 · S/N D-6260N629TGarrard Nathan M · Winston, ORS/N D-5752N62AUFaust Richard J · Richmond, TXBuilt 1981 · S/N EA-247N62BJCapital Dental Management Inc · Dover, DEBuilt 1973 · S/N D-9414N62BSBasmadjian Aram · Macungie, PABuilt 1962 · S/N D-6986N62BVTichy John M · Long Bch Twp, NJBuilt 1979 · S/N MC-649N62CJMcclain Dean L · Torrington, WYBuilt 1962 · S/N BA-633N62EMHarris Jesse C IV · Laurel Park, NCBuilt 1966 · S/N D-8081N62GBBeavers Glenn A · Wichita Falls, TXBuilt 1967 · S/N D-8566N62GMRankin Ty · Amarillo, TXBuilt 1980 · S/N E-1713N62JBHcb Media LLC · Los Angeles, CAS/N E-1160N62JRN62jr LLC · Lakeside, MTBuilt 1988 · S/N CE-1298
Back to AD 99-05-13 R1 WD