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.

N8545DFour-Five-Delta LLC · Mountainville, NYBuilt 1957 · S/N 22-5776N8548CMapes Peter B · Oscoda, MIBuilt 1953 · S/N 22-1251N8548LNiagara Soaring Club Inc · Williamsville, NYBuilt 1969 · S/N 25-4968N8550CBig Sky Communication & Cable Inc · Billings, MTBuilt 1953 · S/N 18-2697N8550DRiester Gary R · Navarre, FLS/N 22-5782N8550LHigh Desert Soaring Clubinc · Bend, ORBuilt 1969 · S/N 25-4970N8551CRautiola Charles A · Rosemount, MNS/N 18-2709N8551LQuality Avition Inc · Marana, AZS/N 25-4971N8552CSchaefer Douglas Lee · Victoria, TXBuilt 1964 · S/N 182698N8552DSvec Adolph Ralph · Marengo, ILBuilt 1957 · S/N 22-5784N8552LWhittington John H Jr · Dillon, SCBuilt 1971 · S/N 25-5423N8553CNext Flight Out Ltd · Wilmington, DEBuilt 1953 · S/N 18-2699N8554DParks Alan J · Homer, AKBuilt 1957 · S/N 22-5786N8555LNorth Shore Aircraft Leasing Co LLC · Waialua, HIBuilt 1969 · S/N 25-4976N8557DWells Michael D · Wilton, MEBuilt 1957 · S/N 22-5789N8558LStar Ads Inc · Torrance, CABuilt 1971 · S/N 25-5418N8559CJones Donald T · Barrigada, GUS/N 18-2711N8560CGuy James L P · Wasilla, AKBuilt 1953 · S/N 18-2713N8560DMachovsky Andrew J · Mesa, AZS/N 22-5794N8560LKnutson Wayne R · Thompson, NDS/N 25-4981N8562DKrupinski Floyd M · Chugiak, AKFirst renewal noticeBuilt 1957 · S/N 18-6212N8563CPearson Ronald M · Sutton, AKS/N 18-2712N8566CGamble Cody M · Palmer, AKBuilt 1958 · S/N 18-6398N8567DBelleau Thomas D · Anchorage, AKBuilt 1959 · S/N 18-6785N8568CCavanaugh Darrel N · Wasilla, AKBuilt 1953 · S/N 18-2723N8568DSmith Lowry Trustee · Leedey, OKBuilt 1958 · S/N 18-6222N8569CRudd Wayne G · Basalt, COBuilt 1954 · S/N 18-2720N8569DRegistration Pending · Willow, AKRegistration pendingBuilt 1958 · S/N 18-6223N8570CMoos Jacob W · Dillingham, AKBuilt 1953 · S/N 18-2722N8572DRubbert Jan D · Upham, NDBuilt 1958 · S/N 18-6228N8572LSky Soaring Inc · Hampshire, ILBuilt 1969 · S/N 25-4996N8573COcean Aerial Ads Inc · Ocean City, MDBuilt 1953 · S/N 18-2726N8574CVan Wagner Aerial Media LLC · Hollywood, FLBuilt 1953 · S/N 18-2728N8576CReser Byron G · Walla Walla, WABuilt 1953 · S/N 18-2730N8576YCenterline Holdings LLC · Belgrade, MTS/N 18-8889N8578DCoy Shane A · Nenana, AKBuilt 1958 · S/N 18-6236N8579CSolberg John W · Bismarck, NDBuilt 1953 · S/N 18-2732N8580DKedrowski James L · Wasilla, AKBuilt 1958 · S/N 18-6238N8581DDutch Air LLC · Kalispell, MTBuilt 1957 · S/N 18-6239N8585DMadsen Travis E · New Underwood, SDBuilt 1957 · S/N 18-6244N8586CGifford Thomas L · Canadian, TXBuilt 1953 · S/N 22-1279N8587DSouthard Bryan O · Moneta, VABuilt 1957 · S/N 22-5766N8588LSuper Pawnee LLC · Delafield, WIBuilt 1969 · S/N 25-5013N8589DOhms Jacob · Girdwood, AKBuilt 1957 · S/N 18-6249N858ASeppi Lance R · Hood, CABuilt 1951 · S/N 22-159N8591DConservative Three LLC · Taft, CABuilt 1958 · S/N 18-6251N8592DRussell Terrell G · Isola, MSBuilt 1958 · S/N 18-6252N8593CPockrus Pat B · Mineral Wells, TXBuilt 1953 · S/N 22-1262N8593DTravis Charles E · Fairbanks, AKBuilt 1958 · S/N 18-6256N8594DWilliams Virgil R Jr · Monroe, GABuilt 1957 · S/N 18-6258
Back to AD 99-01-05 R1