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.

N4641QFitzsimons Nicholas T · Covington, LABuilt 1973 · S/N 17261733N4641RWebb Patrick S · Chuckey, TNBuilt 1966 · S/N 28-21394N4641ZZenisek Michael W · Fairfax, IABuilt 1961 · S/N 22-8160N46420Frontier Environmental Solutions Inc · Inyokern, CAS/N 17257256N46423Parrish Aviation Flight Academy LLC · Southlake, TXS/N 17257259N4642NCrouch Lynn DBA Highland Aviation · White House, TNS/N 75-7591N4642RSkyways Group LLC · Greensboro, NCBuilt 1966 · S/N 28-21396N4642VBolster William L · Joshua Tree, CABuilt 1978 · S/N VAC-96-78N4642WHash Marshall W · Crumpler, NCS/N 13172N46430J & Dk LLC · Overland Park, KSBuilt 1968 · S/N 17257263N46433Plummer Fred C · Normal, ILBuilt 1968 · S/N 17257264N46435Hawkins County Sports Wings Inc · Kingsport, TNBuilt 1968 · S/N 17257266N46436Aero Science International LLC · Martinez, GABuilt 1968 · S/N 17257267N46437Arizona Active Air LLC · Yuma, AZBuilt 1968 · S/N 17257268N46440Engelskirger Karl D · Valley City, OHS/N 17257270N46442Lott Terence D · Florence, MSBuilt 1968 · S/N 17257272N46448Mac Air Inc · Farmington, MOBuilt 1968 · S/N 17257276N46449Tilma Flying Club Inc · Moscow, IDBuilt 1968 · S/N 17257277N4644JWinslow Francis E III · Raleigh, NCS/N 17273659N4644VHendricks Trenton Q · Bow, WABuilt 1978 · S/N VAC-98-78N4644YState Of Montana · Helena, MTBuilt 1971 · S/N 18-8945N4645Ladage Terry L · Champaign, ILBuilt 1979 · S/N 189N46457Ostrowski Sven E · Mullica Hill, NJS/N 17257281N4645JHitchcock Scott B · Waco, TXBuilt 1968 · S/N 28R-30538N4645RKunz Consulting Inc · Sun Prairie, WIBuilt 1966 · S/N 28-21399N4645WClimb Maintain LLC · Morrisville, MOBuilt 1977 · S/N 13175N4646Bailey Christopher J · Riga, MIBuilt 1975 · S/N M-II-480N46460Walter Timothy G · Farmersburg, IABuilt 1968 · S/N 17257283N46462Cook Aviation Services LLC · Fargo, NDBuilt 1968 · S/N 17257285N4646JCulley Johnny C · Amarillo, TXBuilt 1968 · S/N 28R-30539N4646RWarren Global LLC · Chino, CABuilt 1966 · S/N 28-21400N4646VBaran Stephen · Littlestown, PABuilt 1978 · S/N VAC-100-78N46470Registration Pending · St Charles, ILRegistration pendingBuilt 1968 · S/N 17257291N46471Evergreen Avn Space Museum And Captain Michael · Mcminnville, ORS/N G31N46473Aviation Capital Management LLC · San Jose, CABuilt 1978 · S/N 15283056N4647QCowles Charles Orville · Mesa, AZS/N 71576N46484Campisteguy Alexander J · Renton, WABuilt 1968 · S/N 17257298N46486Calimesa LLC · North Las Vegas, NVBuilt 1968 · S/N 17257300N46487Silver Express Co · Miami, FLBuilt 1978 · S/N 15283061N4648HLacore Justin Adam · Mckinney, TXS/N 15-364N4648JTutt Bryan · Louisville, KYS/N 28R-30542N4648MKaye Mykle · Wailuku, HIBuilt 1949 · S/N 14-495N46493Brown Michael F · Richford, NYBuilt 1974 · S/N 17264186N46495Hanna Douglas L · Winchester, KYBuilt 1968 · S/N 17257306N46497Tones Trucking Inc · Cassopolis, MIBuilt 1968 · S/N 17257307N4649MDaviation Inc · Willoughby, OHBuilt 1980 · S/N 15284474N4649QSkyhawk Services LLC · Lake Wales, FLBuilt 1973 · S/N 17261735N4649RHartley Zachary K · Dublin, GABuilt 1966 · S/N 28-21404N464BFMoore John W · Salome, AZBuilt 2024 · S/N 11-001N464CMUniversity Of Central Missouri · Warrensburg, MOBuilt 2000 · S/N 17280856
Back to AD 90-04-06 R1