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.

N67375T Craft Aero Club · Nampa, IDBuilt 1978 · S/N 15281791N6737JWalt Richard A · Whittemore, MIBuilt 1968 · S/N 28-24448N6737NCox James G · Yankton, SDBuilt 1968 · S/N 680186N6737PEhni Scott M · Trinity, TXBuilt 1960 · S/N 24-1865N67381Leustek Thomas A · Willow River, MNBuilt 1978 · S/N 15281797N67383Glover Matthew B · Seaboard, NCBuilt 1978 · S/N 15281799N67384Flying Twenties Inc · San Jose, CABuilt 1978 · S/N 15281800N67387Florida Flight Training Center Inc · Venice, FLBuilt 1978 · S/N 15281803N6738WRussell Christopher E · Pontotoc, MSBuilt 1965 · S/N 28-20858N67398Jet & Rotor Aviation LLC · Sacramento, CABuilt 1978 · S/N 15281814N6739BDeal Stuart F · Santa Rosa, CABuilt 1956 · S/N 22-4072N6739JRafferty Larry M · Mount Vernon, OHBuilt 1968 · S/N 28-24453N6739NMeyer Ross · Apollo Beach, FLBuilt 1968 · S/N 680187N673ACCook Andrew S · Sheridan, INBuilt 2008 · S/N 2N673ASRodriquez Adrian · Miami, FLBuilt 1978 · S/N 38-78A0285N673CTCentral Texas College · Killeen, TXBuilt 2017 · S/N 2844169N673DWSunrise Aviation Inc · Ormond Beach, FLBuilt 1999 · S/N 17280771N673HHaddix Daniel R · Buena Park, CABuilt 2002 · S/N 21673N673JFHall Matthew P · Fowlerville, MIBuilt 1967 · S/N 59N673LJLegg Daniel T · Knoxville, TNBuilt 1976 · S/N 22-1414N673MALewis University · Romeoville, ILBuilt 1999 · S/N 17280741N673SCSpartan Education LLC · Tulsa, OKBuilt 2021 · S/N 2881438N673SP673sp LLC · Blaine, MNBuilt 2000 · S/N 172S8633N67405Cal Aggie Flying Farmers Inc · Davis, CABuilt 1978 · S/N 15281819N67407Reeb Franklin B · Montross, VABuilt 1978 · S/N 15281820N6740LAslesen Leasin LLC · Halstad, MNBuilt 1974 · S/N 18-7409119N6740NGraham Bruce A · Port Saint Joe, FLBuilt 1968 · S/N 680188N6740UJust Air LLC · Victorville, CABuilt 1963 · S/N 166N67410Sky Chiefs Aviation LLC · Gainesville, FLBuilt 1978 · S/N 15281823N6741BPoehler Fred G · Newberg, ORBuilt 1956 · S/N 22-4074N6741LMountain Aviation Corp · Mccall, IDBuilt 1974 · S/N 18-7409121N6741PBall William E · Amarillo, TXBuilt 1960 · S/N 24-1869N6741TCavanaugh Flight Museum · Denison, TXBuilt 1966 · S/N R-172-0127N67420Coor Colin F · Honolulu, HIBuilt 1978 · S/N 15281827N6742JGannone Nanette V · El Prado, NMBuilt 1968 · S/N 28-24827N6742WMidnight Flight LLC · Wells, TXS/N 28-20863N67431Robinson Candace A · Long Beach, CABuilt 1978 · S/N 15281831N6743FHollywood Biplane LLC DBA · Atlanta, GABuilt 1976 · S/N 28-7715176N6743HCape Fear Aviation Maintenance LLC · Fayetteville, NCBuilt 1975 · S/N 17265562N6743JStader Noah M · Platteville, WIS/N 28-24459N6743NHollingsworth Michael J · Phoenix, AZBuilt 1968 · S/N 680059N67440Walford Richard M · Shreveport, LABuilt 1978 · S/N 15281835N67443Air-O-Drome Aviation LLC · Caldwell, IDBuilt 1978 · S/N 15281836N67444Odell Eugene S · Yakima, WABuilt 1978 · S/N 15281837N67448Classen Linda · Mustang, OKFirst renewal noticeBuilt 1978 · S/N 15281840N6744DDyer Randall J · Frazier Park, CAS/N 2238N6744NVan Benschoten Mark T · Linwood, MIBuilt 1968 · S/N 680190N6744UMelia Alexander A · Jacksonville, FLBuilt 1963 · S/N 170N67452Larkin Lucia V · Salome, AZBuilt 1978 · S/N 15281843N67454Naff Peter B · Memphis, TNS/N 75-4982
Back to AD 90-04-06 R1