OpenAirDocs.org
AD 90-06-03 R1

Registered aircraft · 20,683

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-06-03-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-06-03-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.

N4836GEvolo Aviation LLC · Worthington, OHBuilt 1979 · S/N 17273384N4839GPaw Lifter Aero LLC · Madison, INBuilt 1979 · S/N 17273386N483EAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 1979 · S/N 17273688N483EREmbry Riddle Aeronautical University · Daytona Beach, FLBuilt 2019 · S/N 172S12254N483RJMccomas Darryl E · Happy Jack, AZBuilt 1967 · S/N 17256359N483SPScandinavian Aviation Academy Inc · El Cajon, CABuilt 1998 · S/N 172S8029N4841DDoorglobe Inc · San Francisco, CABuilt 1979 · S/N 17272371N4844FKnightair Enterprises LLC · Caro, MIFirst renewal noticeBuilt 1979 · S/N 17273088N4844JSkoglun Eric W · Cashmere, WABuilt 1979 · S/N 17273684N4845GNation Linda S · Sanford, FLBuilt 1979 · S/N 17273392N4845JL&J Aviation Inc · Atwater, CABuilt 1979 · S/N 17273685N4846GNavy Annapolis Flight Center Inc · Edgewater, MDBuilt 1979 · S/N 17273393N4847GFlying Daze · Batavia, OHBuilt 1979 · S/N 17273394N4849DN4849d LLC · North Logan, UTBuilt 1979 · S/N 17272372N484CSTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13484N484ERWisconsin Aviation-Four Lakes Inc · Madison, WIBuilt 2001 · S/N 172S8944N4850GPeters Walter C · Rockford, ILBuilt 1979 · S/N 17273397N4851GEye Candy Aviation LLC · Jacksonville, FLBuilt 1979 · S/N 17273398N4852GR&R Aero Services LLC · Eden Prairie, MNBuilt 1979 · S/N 17273399N4852VR & R Aviation Services LLC · Darien, ILS/N 172RG0400N4854GMilwaukee Aero LLC · Milwaukee, WIBuilt 1979 · S/N 17273401N4855GWings Over Texas Holdings LLC · Denton, TXBuilt 1979 · S/N 17273402N4856DOlsen Ernest D · Lino Lakes, MNBuilt 1979 · S/N 17272374N4856GNatchez Flight Training LLC · Natchez, MSBuilt 1979 · S/N 17273403N4856VColombie Michael A · Anchorage, AKBuilt 1980 · S/N 172RG0401N4857GVero Technical Support Inc · Pensacola, FLS/N 17273404N4857VNewsouth Aviation LLC · Auburn, ALBuilt 1980 · S/N 172RG0402N4859FRidgway Stephen · Avon, COBuilt 1979 · S/N 17273089N4859GAirgo Inc · Centralia, ILBuilt 1979 · S/N 17273406N485GRegistered aircraftBuilt 1980 · S/N 172RG0306N485JMSanders Flight Training Center Inc · Jasper, ALBuilt 2025 · S/N 172S13465N485SBLyddon Aero Center Inc · Liberal, KSBuilt 1978 · S/N 17271485N485VL & W Leasing LLC · Smyrna, TNBuilt 1999 · S/N 172S8316N4861GFlying Colors Airparts Inc · Leesburg, FLBuilt 1979 · S/N 17273408N4861VRegistered aircraftBuilt 1980 · S/N 172RG0403N4864DChiota Aviation LLC · Waco, TXFirst renewal noticeBuilt 1979 · S/N 17272377N4864GLazy Eights Holdings LLC · Greenwood, INBuilt 1979 · S/N 17273411N4865DBlack Hound Aviation LLC · Austin, TXS/N 17273904N4867DFlynn Brian · Auburndale, FLBuilt 1979 · S/N 17272378N4868EVero Technical Support Inc · Pensacola, FLBuilt 1978 · S/N 17271671N486ERUw Flying Club Inc · Sun Prairie, WIBuilt 1998 · S/N 17280672N486MSInternational Air Services Inc Trustee · Carson City, NVS/N 172RG0369N4870DSherman Hess M · Poplar Grove, ILBuilt 1979 · S/N 17272379N4870GCal Aggie Flying Farmers Inc · Davis, CABuilt 1979 · S/N 17273417N4871VBt Aero Precission Flight Accademy LLC · Oakdale, CABuilt 1980 · S/N 172RG0406N4872DPs N4872d LLC · Green Bay, WIBuilt 1979 · S/N 17272381N4873G4873g Flying Club Inc · Punxsutawney, PABuilt 1979 · S/N 17273420N4876FCosta Air Service LLC · Painted Post, NYBuilt 1979 · S/N 17273094N4876GKing Bryan A · Austin, TXBuilt 1979 · S/N 17273423N4877DAviator Air Flight School LLC · Grand Prairie, TXBuilt 1979 · S/N 17272383
Back to AD 90-06-03 R1