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.

N6949ZTide Water Soaring Society Inc · Windsor, VABuilt 1964 · S/N 25-2696N694ABGoldpick Dirtworx LLC · Wasilla, AKBuilt 1957 · S/N 22-5347N694ARWilliams Robert R · Vernonia, ORBuilt 1947 · S/N 12-1507N6950BLudwig Henry H · Fort Worth, TXBuilt 1956 · S/N 22-4238N6950DFaught Jeffrey R · Bismarck, NDS/N 22-4879N6950KGerhold Jeremy R · Rosharon, TXBuilt 1950 · S/N 20-55N6952BWesley Jerry A · Moorland, IAS/N 22-4232N6952KPoor Jeffrey L · Bettles, AKS/N 20-57N6953DLambert Hubert D Sr · Lincolnton, NCBuilt 1957 · S/N 22-4882N6953KJessup Robert L · Carson City, NVS/N 20-46N6955DGlover Thomas B · Marana, AZFirst renewal noticeBuilt 1957 · S/N 22-4884N6956BBushplane Lab LLC · Wilderville, ORBuilt 1956 · S/N 22-4237PN6956KEdwards Stephen L · Wasilla, AKBuilt 1950 · S/N 20-60N6957BVaughn James R · Winchester, KYBuilt 1956 · S/N 22-4239N6960KTillman William L · Virginia Beach, VABuilt 1950 · S/N 20-64N6961BTrimmer Marvin E · Willow, AKBuilt 1956 · S/N 22-4243N6962KBast William B · Fairbanks, AKBuilt 1950 · S/N 20-66N6963DAbu Trailers Inc · Dwight, NDBuilt 1957 · S/N 18-5541N6965DFondy Victor L · Whitewood, SDBuilt 1957 · S/N 18-5543N6967DShamwari LLC · Thibodaux, LAS/N 18-5548N6967KWeight Malcolm E · Spanish Fork, UTBuilt 1950 · S/N 20-71N6969HGittlein Matthew P · Wasilla, AKBuilt 1974 · S/N 18-7409061N696RJWeitman Jim Trustee · Decatur Island, WAFirst renewal noticeBuilt 1953 · S/N 18-3363N696SMSk Aircraft LLC · Anchorage, AKBuilt 1954 · S/N 18-3309N6970BVan Wagner Aerial Media LLC · Hollywood, FLS/N 18-5090N6970ZWilliams Michael C · Fort Walton Beach, FLS/N 25-2717N6971DVan Wagner Aerial Media LLC · Hollywood, FLS/N 18-5497N6971KHarper Ken C · Kenai, AKS/N 20-76N6972KCawley Rebecca L Personal Representative · Lewiston, IDBuilt 1950 · S/N 20-77N6973KSmith Scott B · Sterling, AKBuilt 1950 · S/N 20-78N6974BHill Karl D · Igiugig, AKBuilt 1957 · S/N 18-5095N6978BVantrease Jerold Lee · Homer, AKS/N 18-5100N6978KMoore Jeffrey D · Blossvale, NYS/N 20-81N6979DKohlhase Amy M · Anchorage, AKBuilt 1957 · S/N 18-5507N6980DJohnson Tracy L · Magnolia, TXS/N 18-5508N6981BTownsend Monte A · Wasilla, AKS/N 18-5103N6982ZButler Marine Aviation Inc · Alexandria, VABuilt 1964 · S/N 25-2729N6983BWiltz Paul E · Opelousas, LAS/N 18-5105N6983DGoebel William R · Rhome, TXBuilt 1957 · S/N 18-5511N6984BBig Q Aviation Corp · Helena, MTBuilt 1956 · S/N 18-5106N6984KRjr Airdrome Inc · Dover, DEFirst renewal noticeBuilt 1950 · S/N 20-90N6985DRegistration Pending · East Gull Lake, MNRegistration pendingBuilt 1957 · S/N 18-5514N6987BState Of Alaska · Kodiak, AKBuilt 1956 · S/N 18-5109N6987DBorror Bryce C · Gerber, CABuilt 1957 · S/N 18-5518N6989BHolzman Douglas S · White Salmon, WABuilt 1956 · S/N 18-5111N6990BE T Wells Inc · Helena, ARBuilt 1956 · S/N 18-5112N6990DHorn Paul · Kodiak, AKBuilt 1957 · S/N 18-5522N6990KReeves Donald L · Harrison Township, MIS/N 20-96N6990ZWabash Valley Soaring Association Inc · Lawrenceville, ILBuilt 1964 · S/N 25-2740N6991KMoore Jeffrey D · Blossvale, NYBuilt 1950 · S/N 20-97
Back to AD 99-01-05 R1