AD 94-05-05 R1

Registered aircraft · 26,232

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:94-05-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:94-05-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.

N70539Huntington Thomas R Jr · Ormond Beach, FLS/N 17548N7053APearsall Timothy R · Rexford, NYBuilt 1956 · S/N 29153N7053UWaterman James T · San Antonio, TXBuilt 1988 · S/N 115N70548Klingebiel Sean R · Schuylerville, NYS/N 17557N7054AOtt Rex A · Burlington, IABuilt 1956 · S/N 29154N7055EKleinschmidt Eric W · Livermore, CABuilt 1960 · S/N 56555N70561Maples Charles S · Fairfax, VABuilt 1946 · S/N 17570N7056THeinke John R · Paradise, CABuilt 1958 · S/N 46656N7057EKoser Michael D · Asheboro, NCBuilt 1960 · S/N 56557N7058FTechnical Education Services Inc · Virginia Beach, VAS/N 15063658N7059AWebster Mark Lawrence · Frankston, TXBuilt 1956 · S/N 29159N7059EPennell Zackaria S · Canyon Lake, TXS/N 56559N7059TBrommer Roger A · Lino Lakes, MNBuilt 1959 · S/N 46659N705TDFlight Gear Aviation LLC · Pickerington, OHS/N 15069561N70604Cole Audrey L · Anchorage, AKBuilt 1946 · S/N 17613N70605Zabinski Ted W · Voorheesville, NYS/N 17614N7060AWalker Jonathan S · Council Bluffs, IABuilt 1956 · S/N 29160N7060EBrenner Valerian · Port Saint Lucie, FLBuilt 1960 · S/N 56560N7060SDygas Pauel · Pomerene, AZS/N 15067760N70614Flaspoehler Benjamin P · Greenville, SCS/N 17623N70615Malinchak Joseph G · Greenfild Twp, PABuilt 1946 · S/N 17624N7061SDirar Farras S E · Sackets Harbor, NYBuilt 1967 · S/N 15067761N7062SPrecision Aerospace Corp · Sarasota, FLBuilt 1967 · S/N 15067762N7062TJardd Inc · Lorain, OHBuilt 1959 · S/N 46662N7063ASexton Forest · Eagle Point, ORBuilt 1956 · S/N 29163N7063HN7063h Inc · Miami, FLBuilt 1946 · S/N 20310N7063TMorris Coady C · Russell, KSS/N 46663N7064ASelby Joshua F · Condon, ORBuilt 1956 · S/N 29164N7064EBolognese Joseph · Las Vegas, NVS/N 56564N7064SCuddington Mark E · Puyallup, WAS/N 15067764N70656Rawliuk Robert A · Tok, AKBuilt 1946 · S/N 17676N7065AJahnke Michael D · Wichita, KSBuilt 1956 · S/N 29165N7065MPamair Inc · Wilmington, DEBuilt 1958 · S/N 55365N7065TRegistered aircraftBuilt 1959 · S/N 46665N7066ANewton Consulting & Engineering Inc · Tucson, AZBuilt 1956 · S/N 29166N7066EBarnes Stephen W · Mustang, OKBuilt 1960 · S/N 56566N7066FLamb Barry J · Moran, KSBuilt 1966 · S/N 15063666N70675Lavigne Richard P · Ranier, MNS/N 17695N7067AWhitemire Jospeh A · Soddy Daisy, TNBuilt 1956 · S/N 29167N7067E5 Am Equipment LLC · Casper, WYBuilt 1960 · S/N 56567N7067TSmith Roy Harold · Whiteville, NCBuilt 1959 · S/N 46667N7067XAlpha Golf LLC · Glenpool, OKBuilt 1961 · S/N 15059167N7068AMcdonald Ronald B · Arcadia, FLBuilt 1956 · S/N 29168N7068EMarino Farms LLC · Macon, MOS/N 56568N7068FAndrew David N · Manhattan, ILBuilt 1966 · S/N 15063668N7068MStaples Norman J · Sussex, WIBuilt 1958 · S/N 55368N7069EPinnell John T · Bakersfield, CAS/N 56569N7069MJohnson Roger N · Winnemucca, NVBuilt 1958 · S/N 55369N7069THovey Terry W · Rogue River, ORBuilt 1959 · S/N 46669N706JDBartels Gary A · Daykin, NEBuilt 2007 · S/N JD 4
Back to AD 94-05-05 R1