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.

N6265ZAerial Banners Inc · Pembroke Pines, FLBuilt 1960 · S/N 25-327N6266ZLinzel Jesse Gray Jr · Southern Pines, NCBuilt 1960 · S/N 25-329N6267ZGordon Strom B Jr · Paris, TXBuilt 1960 · S/N 25-332N6268ZKnutson Wayne R · Tioga, NDBuilt 1960 · S/N 25-333N626DCFlying For Conservation LLC · Juda, WIBuilt 1959 · S/N 18-7099N62706Whitney Clark G · Soldotna, AKBuilt 1977 · S/N 18-7709135N62712Chandler Air Service Inc · Chandler, AZBuilt 1978 · S/N 18-7809105N62742Everingham Bros Bait Co · National City, CABuilt 1978 · S/N 18-7809108N62744Kittle Cory L · Eagle River, AKBuilt 1978 · S/N 18-7809109N62751Carr James C · Wasilla, AKBuilt 1977 · S/N 18-7709160N6279ZFlint River Soaring LLC · Bainbridge, GABuilt 1960 · S/N 25-346N627YGlaser Donald E DBA · Willow, AKBuilt 1946 · S/N 12-47N62873Sky Sailing Inc · Warner Springs, CABuilt 1978 · S/N 25-7856061N6291ZBordelon Thomas D · Elephant Butte, NMBuilt 1960 · S/N 25-361N6292YHardesty George J · South Bend, INS/N 226300N6296NBurg Clinton A · Creswell, ORBuilt 1957 · S/N 18-5696N629AKCloward Marc D · Cordova, AKBuilt 1951 · S/N 18-122N62RTLowell William · Caldwell, IDS/N 18-7609038N6304ZVintage Aero Sports LLC · Easton, PABuilt 1960 · S/N 25-388N6319DBores Scott J · Huron, OHS/N 20-998N6319ZSouthern Cub & Aircraft Restoration LLC · Pensacola, FLBuilt 1960 · S/N 25-412N6324DSmart Charles R · Verden, OKBuilt 1954 · S/N 22-2387N632ACarroll Dana C · Wirtz, VABuilt 1951 · S/N 22-35N633AMoeckly Steven L · Polk City, IABuilt 1951 · S/N 22-36N6346Barnhart William C III · Whitewood, SDS/N 111321N63557Western Antique Aeroplane & Automobile Museum · Hood River, ORS/N 5-1465N6355ZQuality Aviation Inc · Marana, AZBuilt 1961 · S/N 25-519N636AMott Timothy B · Hayden, IDS/N 22-41N636PGlenn R Johnson Trustee · Calmar, IABuilt 1967 · S/N 18-8630N637ASnyder Kenneth E · Tiffin, OHS/N 22-39N63803Southern California Soaring Academy Inc · Valencia, CABuilt 1978 · S/N 18-7809147N63805Boettner Joseph M · Anchor Point, AKBuilt 1978 · S/N 18-7809110N63822Coale Douglas A · Santa Ynez, CABuilt 1979 · S/N 18-8009023N63837Schuler George M IV · Breckenridge, MNS/N 18-7809149N63848Hober Holding Co · Easton, CTBuilt 1978 · S/N 18-7809150N6384ZNeal Aviation Inc · Staples, MNBuilt 1961 · S/N 25-506N6385ZDoyle Danny G · Mckinney, TXS/N 25-508N6387ZJ T D LLC · North Platte, NES/N 25-510N63907Brad & Jill Janecke LLC · Pierre, SDBuilt 1979 · S/N 18-8009022N63928Piper Aircraft Inc · Vero Beach, FLBuilt 1979 · S/N 18-8009024N6392TClapp William H · Mountain View, MOS/N 18-7396N63943Terrill Guy J · Dillon, MTBuilt 1979 · S/N 18-8009025N6394NAlleva John A · Wasilla, AKS/N 18 5155N63964Stitzel Michael M · Cove, ORS/N 18-8009030N6398BHanson Charlotte A · Palmer, AKBuilt 1946 · S/N 12-382N639ABerry Gary D · Oakdale, CAS/N 22-43N63JWRegistered aircraftBuilt 1977 · S/N 18-7709139N6410WChandler Robby · New Hope, ALS/N 18-8178N641ABroers Daniel Gt · Libby, MTS/N 22-44N641RHJakes Guide Service LLC · Willow, AKS/N 18-8388
Back to AD 99-01-05 R1