AD 90-02-13

Registered aircraft · 3,863

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-02-13')
    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-02-13')
  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.

N3068LMirage Air Ltd · Wilmington, DENon-citizen corporation, flight hours not reportedS/N 310J0068N3069DSmith Gregory E · White Lake, MIBuilt 1956 · S/N 35269N306PMBc 414 LLC · Vineyard Haven, MABuilt 1979 · S/N 414A0419N306TBApex Aviation Holding LLC · Kalispell, MTBuilt 1982 · S/N 340A1537N3070LClark Kenneth N · Tempe, AZBuilt 1965 · S/N 310J0070N3071LRegistered aircraftBuilt 1965 · S/N 310J0071N3073LSheakley John W DBA · Meadville, PABuilt 1965 · S/N 310J0073N3075LAlvis Michael E · Parkton, NCS/N 310J0075N3079LTff Inc · Parma, MIBuilt 1965 · S/N 310J0079N307FMNorris Aviation LLC · Mansfield, TXBuilt 1977 · S/N 421C-0323N3083LPrice Randy L · Pahrump, NVS/N 310J0083N3088LRice James M · Austin, TXS/N 310J0088N3091DBella Farms Inc · Hayes Center, NEBuilt 1956 · S/N 35291N3091LAbbasi Babak · Murrieta, CABuilt 1965 · S/N 310J0091N3094DAberdeen Pilots LLC · Boerne, TXBuilt 1956 · S/N 35294N3095DIrvine William G · Rosamond, CABuilt 1956 · S/N 35295N30DTShelton Sharon Shay · Abilene, TXS/N 414-0910N30EEEnterprises Aviation Inc · Piedmont, SDBuilt 1979 · S/N 414A0443N30FBBmg Aviation Leasing LLC · Bloomington, INBuilt 1978 · S/N 414A0067N30HBN30hb LLC · North Miami, FLS/N 340-0786N30HCKinetic Concepts LLC · Pensacola, FLS/N 310Q1079N30LPDialysis Clinic Inc · Nashville, TNBuilt 1977 · S/N 310R0995N30LTJuans Adios LLC · Newark, DES/N 421C0290N30PTGas Aviation LLC · Decatur, TNBuilt 1976 · S/N 421C0157N30RWSaltzy Seas LLC · Loxahatchee, FLBuilt 1976 · S/N 310R0667N30SSN30ss LLC · Dover, DEBuilt 1973 · S/N 414-0451N30TAero Quest LLC · Olive Branch, MSBuilt 1962 · S/N 310G-0031N3101TMission Air LLC · Charlotte, NCS/N 310R1877N310ACJulie Dorst LLC · Kalispell, MTBuilt 1975 · S/N 310R0290N310AFSelwa Michael A · Oconomowoc, WIBuilt 1974 · S/N 310Q1121N310AHGraydon Bilal R · Melbourne, FLBuilt 1979 · S/N 310R1660N310AJPj Aviation Holding LLC Trustee · Eden Prairie, MNBuilt 1980 · S/N 310R1606N310ARHales Gutter Guys LLC · Cottonwood, AZS/N 310R1387N310ATBelknap Scott M · Temecula, CABuilt 1965 · S/N 310J0097N310AWBetty Eric · Old Hickory, TNBuilt 1969 · S/N 310P0231N310BBF & F Aviation LLC · Memphis, TNS/N 310R1858N310BDSale Reported · Fort Wayne, INSale reportedBuilt 1965 · S/N 310J0013N310BGFlairships LLC · Durham, NCBuilt 1977 · S/N 310R0889N310BJJ A Flight Services LLC · Sugar Grove, ILBuilt 1973 · S/N 310Q0759N310BMTeam 67 LLC · Mount Pleasant, IABuilt 1973 · S/N 310Q0987N310BSKwe Inc · Melbourne Beach, FLBuilt 1973 · S/N 310Q0822N310BVExec Air Inc Of Naples · Naples, FLBuilt 1974 · S/N 310R0099N310CBN310cb LLC · Buford, GABuilt 1975 · S/N 310R0600N310CCLance Johnson Ministries Inc · Calhoun, GABuilt 1973 · S/N 310Q0970N310CFSouthern Illinois University DBA · Murphysboro, ILBuilt 1975 · S/N 310R0565N310CGHoffert Stephen · Alexander, NCBuilt 1978 · S/N 310R-1304N310CJCj Marketing Inc · Saint John, INS/N 310R0223N310CKSt Charles Flying Service Inc · Portage Des Sioux, MOBuilt 1980 · S/N 310R-1889N310CLSinclair Bradley W · Melbourne, FLBuilt 1981 · S/N 310R2138N310CMAir Positive LLC · Selbyville, DEBuilt 1969 · S/N 310P-0178
Back to AD 90-02-13