OpenAirDocs.org
AD 99-01-05 R1

Registered aircraft · 10,639

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-01-05-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-01-05-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.

N4420YKingsley Kiman J · Miller, MOBuilt 1966 · S/N 25-4040N4420ZRuff Gregory Z · Red Bluff, CAS/N 18-8756N4421HShort Don H · Haskell, OKS/N 15-206N4422AHackwell Calvin · Enoch, UTBuilt 1956 · S/N 22-3751N4423HRailing Terry L · Lake Mills, WIBuilt 1948 · S/N 15-210N4423MBarts Flying Service Inc · Storm Lake, IABuilt 1947 · S/N 12-3374N4423ZThompson Daniel P · Marianna, ARS/N 18-8759N4424AHulme Randi M · Kimberly, IDBuilt 1956 · S/N 22-3753N4424MPeedin John J · Littleton, NCBuilt 1947 · S/N 12-3377N4424ZChmiel John E · Rhinelander, WIFirst renewal noticeBuilt 1969 · S/N 18-8761N4425HTurner William J · Twentynine Palms, CABuilt 1948 · S/N 15-211N4425MCoxon Allan · Ford, WABuilt 1947 · S/N 12-3376N4425ZSale Reported · Quincy, WASale reportedBuilt 1968 · S/N 18-8762N4426AShankle Matthew B · Culpeper, VAS/N 22-3755N4426HLovley Vaughn T · Webster, MNBuilt 1948 · S/N 15-212N4427ARhinehart Daniel · Placentia, CABuilt 1956 · S/N 22-3756N4427ZLanders Russell R · Tok, AKBuilt 1969 · S/N 18-8765N4428HBowman Billy G · Gold Hill, NCS/N 15-213N4428MMittelstadt Garret A · Oakfield, WIBuilt 1947 · S/N 12-3380N4428PSilver Creek Glider Club · New Douglas, ILBuilt 1964 · S/N 25-2719N4428YCherry Hill Aviation Inc · Freetown, INS/N 25-4053N4428ZRegistered aircraftBuilt 1968 · S/N 18-8766N4429APrillwitz Nolan D · Appleton, WIBuilt 1956 · S/N 22-3758N4429YBlackstone Aircraft LLC · Hartselle, ALS/N 25-4055N4429ZAerial Crop Care Co · Hebron, NDBuilt 1968 · S/N 18-8767N442AAbrams Gary L · Tucson, AZS/N 1809079N4430HKromer Jack F · Mount Carroll, ILBuilt 1948 · S/N 15-218N4430YEvergreen Soaring Inc · Lynnwood, WABuilt 1966 · S/N 25-4056N4430ZLorimor Thomas T · Sidney, IABuilt 1968 · S/N 18-8768N4431AResetarits Matthew · West Seneca, NYBuilt 1956 · S/N 22-3760N4431HHood William E · Dover, NCBuilt 1948 · S/N 15-216N4431ZRegent Trust Corp Trustee · Wichita, KSS/N 188769N4432ZTennant Carol J · Camp Crook, SDS/N 18-8771N4433MAlberco LLC · Northport, MEBuilt 1947 · S/N 12-3386N4433ZBoll Nathan · Newburg, NDBuilt 1968 · S/N 18-8772N4434APutnam Michael D · Arnold, MOBuilt 1956 · S/N 22-3763N4434HJenkins James L · Lake Stevens, WABuilt 1948 · S/N 15-223N4434ZWings Over Water Inc · Minneapolis, MNS/N 18-8774N4435MMerrill Patrick A · Winston Salem, NCBuilt 1947 · S/N 12-3387N4435ZDevereaux Saw Mill Inc · Pewamo, MIS/N 18-8775N4436DLippert Rodney C · Milwaukie, ORS/N 18-4932N4436MKelsey Mike · Carey, IDBuilt 1947 · S/N 12-3389N4437MStrawn Richard B · Fruitland, IDS/N 12-3388N4438HTarpley David A · Cleveland, GABuilt 1948 · S/N 15-225N4438ZCan-Am Aero LLC · Tulsa, OKBuilt 1969 · S/N 18-8781N4439AHenry Kirk S · Uhrichsville, OHBuilt 1956 · S/N 22-3768N4439MUrban Jesse · Sutton, MABuilt 1947 · S/N 12-3392N4440HSommer John J · Seattle, WAFirst renewal noticeBuilt 1948 · S/N 15-228N4440LHutchison John · Big Lake, AKBuilt 1979 · S/N 187909169N4440YMayes Brett R · Williams, CABuilt 1966 · S/N 25-4074
Back to AD 99-01-05 R1