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.

N4925GSchwenker David W · Queensbury, NYBuilt 1979 · S/N 17273472N4925ZKopacz Thomas H · Glen Flora, WIS/N 22-8515N49260Youth Aeronautics Education Foundation · Mattaponi, VABuilt 1977 · S/N 15281209N49261Salem Oregon Flight Training LLC · Salem, ORBuilt 1977 · S/N 15281210N49268Fox John E · Boonville, CABuilt 1977 · S/N 15281213N4926LRedden John V · Mooresville, NCBuilt 1967 · S/N 28-4293N49276Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15281217N4927BAviation Capital Management LLC · San Jose, CABuilt 1979 · S/N 15283709N4927CRegistration Pending · Helena, MTRegistration pending, pending cancellationBuilt 1953 · S/N 18-2116N4927DGreenville Flight LLC · Greer, SCS/N 17272401N4927LProfessional Plastic Solutions LLC · Irving, TXBuilt 1967 · S/N 28-4294N49285Fullerton Airport Pilot Association · Fullerton, CABuilt 1979 · S/N 15283445N49288Wisconsin Aviation Inc · Watertown, WIBuilt 1977 · S/N 15281226N4928BWings Over Texas Holdings LLC · Denton, TXBuilt 1979 · S/N 15283710N4928EAce Of Spades Aviation LLC · Las Vegas, NVBuilt 1978 · S/N 17271676N4928LTwo8lima Llp · Bryan, OHBuilt 1967 · S/N 28-4295N49292Johnson Scott W · Saline, MIS/N 15283446N4929JBurnett Robert E · San Leandro, CABuilt 1968 · S/N 28R-30650N4929LMaak Air LLC · Wahoo, NEBuilt 1967 · S/N 28-4296N4929ZDennis Robert · Rosamond, CAS/N 22-8519N492ACRobinson Mark A · Carson City, NVS/N 002N492BNTurner Harvey Jr · Raleigh, NCBuilt 1967 · S/N 28-4167N492DSSkywest Leasing Inc · St George, UTBuilt 2005 · S/N 40.504N492FLMcknight Anna Mae · Vernon, TXBuilt 1971 · S/N 28-7125306N492JBBorke Michael F · Charleston, SCBuilt 2007 · S/N 90852N492LGSunday Punchers LLC · Monrovia, INBuilt 1979 · S/N AA5A0887N492NDChristiansen Aviation LLC · Wilmington, DEBuilt 2007 · S/N 4496241N492RDOsborne Paul B · Ocala, FLBuilt 2025 · S/N JA 742-10-24N492RVRegistered aircraftBuilt 2014 · S/N 91233N492SFSnohomish Flying Service Inc · Snohomish, WABuilt 1976 · S/N 17268310N492SPChristiansen Aviation LLC · Wilmington, DEBuilt 1998 · S/N 172S8033N492WAirplane Adventures LLC · Palos Heights, ILBuilt 1956 · S/N 23-611N492WPAngel Aviation Inc · Peoria, AZBuilt 1979 · S/N 17272684N492XMcdonald Stuart D · Phoenix, AZS/N REA-001N49305Everything Pitts LLC · Queen Creek, AZBuilt 1981 · S/N 1000N49306Mercer Mark E · Aurora, COBuilt 1981 · S/N 1001N49307Lutes David W · Berryton, KSBuilt 1981 · S/N 1002N49309Newton Thomas L Jr · Fredericksburg, VABuilt 1982 · S/N 1006N4930BSkyranch Knoxville Youth Inc · Knoxville, TNS/N 15283712N4930HSantillan Hannah M · Belgrade, MTBuilt 1948 · S/N 11-802N4930LG Salisbury & Associates Inc · Prescott, AZBuilt 1967 · S/N 28-4297N4930UUniversity Of Oklahoma · Norman, OKBuilt 2005 · S/N 2842241N49312Boyd Timothy · East Point, KYBuilt 1982 · S/N 1008N49314Losacker Matthew S · Chandler, AZBuilt 1983 · S/N 1014N49315Morphew Ben · Mckinney, TXS/N 1013N49319Anderson Richard P · De Leon Springs, FLBuilt 1985 · S/N 1029N4931BWojtowicz Tomasz · Bronx, NYBuilt 1979 · S/N 15283713N4931LThrust Spear Of Tampa LLC · Tampa, FLBuilt 1967 · S/N 28-4299N4931ZThurmond Kenneth · Eastover, NCS/N 22-8521N49324Vfr Ltd · Wilmington, DEBuilt 1943 · S/N 76-530
Back to AD 90-04-06 R1