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.

N44DADuncan Aviation Inc · Lincoln, NEBuilt 1981 · S/N E-1841N44DBSperr David F · Rock Hill, SCBuilt 1959 · S/N D-6074N44DLOdonnell Dennis J · Santa Fe, NMBuilt 1956 · S/N D-4749N44GParish Charles L · Tullahoma, TNBuilt 1946 · S/N B-3N44GMEastern Stearman Inc Trustee · Leesburg, VABuilt 1944 · S/N 6916N44GNMitchell Martin B · Newport Beach, CABuilt 1975 · S/N CE-620N44GZOpdahl Kirk J · Lees Summit, MOBuilt 1993 · S/N CE1725N44KRMcilhenny Edward A · Clayton, GABuilt 1983 · S/N EA-358N44MAPacific Mission Aviation · Hagatna, GUS/N LD-412N44MPMiller Dennis Joseph · Bartlett, TNBuilt 1969 · S/N TE-760N44MTFree Fliers Ma LLC · Sheridan, WYS/N G-11N44NKNist Joseph Anthony II · Pittsburgh, PABuilt 1968 · S/N TE-470N44PBMcpeck Adam S · Agar, SDFirst renewal noticeBuilt 1964 · S/N D-7678N44PEJanssen Willis W · Ault, COBuilt 1957 · S/N D-5169N44RAJohnson Bruce W · Portland, ORBuilt 1965 · S/N TC-916N44SAGniks LLC · Nevada, MOBuilt 1978 · S/N TJ-167N44SBReid Larry Paul · Jasper, GABuilt 1971 · S/N CE-356N44SPAwh Ventures Inc · Houston, TXBuilt 1975 · S/N TE-1036N44TEThomaston Bonanza Club Inc · Thomaston, GABuilt 1975 · S/N E-796N44VBColeman Jack L · Monroe City, MOBuilt 1978 · S/N CE-760N44XFWetzel Jack T · New Port Richey, FLBuilt 1964 · S/N TC-731N44XJRegistered aircraftBuilt 1984 · S/N TJ-478N44YHansen Kenneth · Irvine, CAS/N G-760N44ZMSchnurbusch Larry · Saint Louis, MOBuilt 1978 · S/N E-1279N4503DGingell C Thomas · Montrose, COBuilt 1956 · S/N D-4617N4503SBarber Christian · Mansfield, MABuilt 1975 · S/N CE-594N4504DBeck John A · Collins, OHS/N D-4665N4504SRegistered aircraftBuilt 1975 · S/N E-720N4505SGo Flyers LLC · Sudbury, MABuilt 1975 · S/N CE-596N4506MBig Bend Community College · Moses Lake, WABuilt 1978 · S/N MB-881N4506SBaghs LLC · Fort Lauderdale, FLS/N D-9795N4507DRunia Allan D Trustee · Gold Hill, ORS/N D-4667N4508DKvant Holdings LLC · Hallandale Beach, FLBuilt 1956 · S/N D-4679N4509DAviation Dept LLC · Marietta, GABuilt 1956 · S/N D-4661N450BASimmons Brian R · Heavener, OKBuilt 1981 · S/N M-2342N450CFZieger C Philip · Clearwater Beach, FLBuilt 1978 · S/N TC-2128N450LHSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1979 · S/N TC-2215N450TAKestrel Inc · West Des Moines, IABuilt 1959 · S/N BA-482N450WSMatter Donald Chad Trustee · Friendswood, TXBuilt 1979 · S/N E-1552N450YRSmith John W Jr · Stamps, ARBuilt 1981 · S/N CE-978N4510MRcl Farms Leasing LLC · Bronwood, GAS/N TK-70N4511DGage Lewis Trustee · Reno, NVBuilt 1956 · S/N D-4638N4512DLucarelli Gino P · Goose Creek, SCBuilt 1956 · S/N D-4648N4512NNimbus Aviation LLC · Ponte Vedra Beach, FLBuilt 1944 · S/N 6737N4513MLeopold Aero LLC · Wilmington, DEBuilt 1978 · S/N TE-1127N4514MSpencer Joseph C · Evans, GABuilt 1978 · S/N TC-2129N4515MCooper Steve O · Phoenix, AZBuilt 1978 · S/N CE-767N4515SHarris Aviation LLC · Texarkana, TXBuilt 1975 · S/N E-725N4516DG&L Autosport LLC · Whitestown, INBuilt 1956 · S/N D-4687N4516SConcepcion Carlos L · Pembroke Pines, FLBuilt 1975 · S/N TE-1057
Back to AD 99-05-13 R1 WD