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.

N7603CSorbi Aviation Inc · El Cajon, CABuilt 1979 · S/N ME-230N7607RScott Mark G Jr · Manvel, TXBuilt 1969 · S/N M-1234N7608DSmith Charles Gregory · Richlands, VABuilt 1972 · S/N P-188N7609NPro X Aviation Services LLC · Anderson, INFirst renewal noticeBuilt 1969 · S/N TE-747N760AAce Aircraft Leasing Inc · Nazareth, PABuilt 1979 · S/N ME-303N760BShorter David A · Duncan, OKBuilt 1948 · S/N D-1768N760CNSchumacher Charles · Cambridge, MABuilt 1976 · S/N TC-1929N7610NHarrison Danny L · Byrdstown, TNBuilt 1968 · S/N TC-1137N7611BCason Thaddeus D · Polk City, FLS/N M-1399N7612RSamper Aviation LLC · Easton, PABuilt 1969 · S/N M-1235N7613NN7613n LLC · Lewes, DEBuilt 1968 · S/N TE-613N7614RKull Phillip G · Monroe, MIBuilt 1969 · S/N M-1237N7616RMalcom Brett W · Warner Robins, GABuilt 1969 · S/N M-1239N761BMyron Wayne R · Ione, WABuilt 1948 · S/N D-1769N761LTFiddelman Joseph D · Port Orange, FLBuilt 1978 · S/N D-10187N7622NWingswat LLC · Placentia, CABuilt 1968 · S/N TC-1140N7623RAdamiak Jeffrey · Mount Laurel, NJS/N M-1246N7624NUhuru II LLC · Phoenix, AZBuilt 1968 · S/N D-8854N7626RBasinger Weston P · Alexandria, VABuilt 1969 · S/N MA-348N7627RReising Douglas C · Caseyville, ILBuilt 1969 · S/N M-1248N7628RWilson Rodney C · Flagstaff, AZBuilt 1969 · S/N M-1249N762BMedic Choppers LLC · Springdale, ARBuilt 1958 · S/N D-5511N762JTPurdue University · West Lafayette, INBuilt 1981 · S/N ME-432N762TFair Skies LLC · East Meadow, NYBuilt 1973 · S/N D-9434N7633BSo Cal Leasing LLC · El Cajon, CABuilt 1979 · S/N ME-196N763BE-Commerce Education Foundation · Tulsa, OKBuilt 1948 · S/N D-1702N763MMMerrill Mark · Scottsdale, AZBuilt 1976 · S/N TC-1969N7641RDossey Kevin L · Oroville, CABuilt 1969 · S/N MB-432N7642NGomez Eliud · Orlando, FLS/N TE-620N7648RJohnson Jerome L · Victorville, CABuilt 1969 · S/N MB-457N76498Doucey Mark R · The Villages, FLS/N E2607N764DBonanza Partners · Sleepy Hollow, ILBuilt 1951 · S/N D-3034N764DHHess David G Trustee · Chandler, AZS/N CE-1072N764TSullivan Jerald S · Gilbert, AZBuilt 1973 · S/N E-392N7651NScarp LLC · Seabrook, TXBuilt 1968 · S/N TC-1148N7652DGunter Scott · Walters, OKBuilt 1981 · S/N TC-2400N7652NCockrell Kenneth D · Friendswood, TXBuilt 1968 · S/N TC-1147N7653NPieri James A · Gallatin, TNS/N D-8858N7653RBeech Aviators Of Houston LLC · Kingsland, TXBuilt 1969 · S/N MA-353N7654RBeech C23 LLC · Galesburg, KSBuilt 1969 · S/N M-1285N7656RRobinson Lewis S · Irmo, SCBuilt 1969 · S/N M-1260N7657NStewart James D · Mesa, AZBuilt 1968 · S/N TC-1130N7659RThomas Chris C · Mansfield, OHS/N M-1263N765BDukerson Air LLC · Broken Arrow, OKBuilt 2003 · S/N E-3494N765TJohnson Adam D · Denton, TXS/N E-404N7660NGeorge Sterling Gardner Trustee · Elk Grove, CABuilt 1957 · S/N D-5669N7660RWare Joshua A · Inwood, WVBuilt 1969 · S/N M-1282N7669RSpence Lisa A · Houston, TXFirst renewal noticeBuilt 1969 · S/N M-1265N766DBWhelan And Associates Pllc · Eagle, COBuilt 1980 · S/N EA-98N766JWPetrol Properties Inc · Springfield, MOBuilt 1977 · S/N P-421
Back to AD 99-05-13 R1 WD