AD 90-04-06 R1

Registered aircraft · 68,377

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:90-04-06-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:90-04-06-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.

N5504NWighs Terry L · Fairbanks, AKBuilt 1978 · S/N 1264-78N5504QDoll Electric Co Inc · Murphys, CABuilt 1965 · S/N 605N5504SBoomer Aviation Inc · Fort Walton Beach, FLBuilt 1978 · S/N 277-78N5504WTaylor Deric C · Seguin, TXBuilt 1962 · S/N 28-591N5504YTarkington John W · Almyra, ARBuilt 1978 · S/N 423-78N55051Wings Over Texas Holdings LLC · Denton, TXBuilt 1973 · S/N 34-7350166N55055Martan LLC · Kansas City, MOBuilt 1973 · S/N 28-7305301N55057Smooth Air LLC · Churubusco, INBuilt 1973 · S/N 28-7305302N55058Eggensberger Edmund G · Simpsonville, SCS/N 28R-7335174N5505FSerafinowicz Ronald P · Gilbert, AZBuilt 1968 · S/N 28-24844N5505HKupferschmidt W Alan Trustee · Lake Elmo, MNBuilt 1978 · S/N 1038-78N5505LRegistration Pending · Saint Johns, FLRegistration pendingBuilt 1974 · S/N AA5-0505N5505MCapozzi Eugene L · Kalispell, MTBuilt 1978 · S/N 424-78N5505NMargolies Lars · Goldens Bridge, NYBuilt 1978 · S/N 1266-78N5505QReynolds C J · Cornelius, NCBuilt 1965 · S/N 2941N5505UPaper Plane Aviation LLC · Avon Park, FLBuilt 1969 · S/N 28-26215N5505WPerez Daniel E · Parsons, KSBuilt 1962 · S/N 28-592N55064Western Skyways Inc · Montrose, COBuilt 1973 · S/N 28-7325317N55065Lynch Timothy B · Aguadilla, PRBuilt 1978 · S/N 427-78N55066Premier Capital Enterprises LLC · Hurricane, UTS/N 28-7305303N55067Hinsch Delano G · Larchwood, IABuilt 1978 · S/N 428-78N55069Tre Aviation Corp · Wilmington, DEBuilt 1973 · S/N 28R-7335177N5506CBattle Creek Powersports LLC · Jasper, TNBuilt 1978 · S/N 1267-78N5506HWoods George M · Anchorage, AKS/N 1240-78N5506LKoster Michael Richard · Plano, TXS/N AA5-0506N5506MCloud Kicker Aviation LLC · Kalamazoo, MIBuilt 1978 · S/N 1040-78N5506UHumberto Moreno · Mulberry, FLBuilt 1969 · S/N 28-26214N5506WMchatton Dret A · Redding, CABuilt 1962 · S/N 28-593N5506ZOakcrest Management Inc · Brownsville, TXBuilt 1978 · S/N 364-78N55072Lorenzo John V · Tulare, CABuilt 1978 · S/N 1269-78N55075Paris Air Inc · Vero Beach, FLS/N 34-7350170N55078Tiritilli Robert · Mission Viejo, CABuilt 1973 · S/N 28-7325320N5507HAdair Caden S · Anchorage, AKBuilt 1978 · S/N 1273-78N5507LFletcher Alex J · Weston, WIBuilt 1974 · S/N AA5-0627N5507PMccleskey Nicholas J · Mcminnville, ORBuilt 1978 · S/N 1043-78N5507WBurnett Fred · Greenbrier, ARBuilt 1978 · S/N 365-78N55080Keath Brian S · Kansas City, MOBuilt 1973 · S/N 28-7305305N55087Fosso Christopher M · Glendale, AZBuilt 1973 · S/N 28-7305308N55088Slipstream Aviation LLC · Calera, ALBuilt 1973 · S/N 28R-7335178N5508JPaetzold Larry E · Brownwood, TXBuilt 1978 · S/N 1048-78N5508LDe Lint Marcus W · Cove, ORBuilt 1978 · S/N 1049-78N5508MLindvig Thomas H · Williston, NDBuilt 1978 · S/N 1272-78N5508QSchmidt James A · Richmond, VABuilt 1965 · S/N 707N5508WEkkel Bob J · Newaygo, MIBuilt 1962 · S/N 28-596N55094Remedy Aviation LLC · Langford, SDBuilt 1973 · S/N 28-7325322N55096Robinson Jeffrey M · Scottsboro, ALBuilt 1973 · S/N 28-7305311N5509FAhs Aero LLC · Leo, INS/N 28-24850N5509JJet Air Inc · Iowa City, IABuilt 1980 · S/N 17273810N5509QCarlson Jeremy Nathaniel · Arnold, CABuilt 1965 · S/N 2943N5509WKitts John L · New Braunfels, TXBuilt 1962 · S/N 28-597
Back to AD 90-04-06 R1