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.

N6318EEvans Robert W · Upland, CABuilt 1959 · S/N 46418N631AAAerospring Leasing LLC · Wasilla, AKBuilt 2025 · S/N 172S13373N631CTCoast Flight Training And Management Inc · San Diego, CABuilt 2008 · S/N 172S10779N6320FJohn D Strohsahl Pa Trustee · Fort Lauderdale, FLBuilt 1979 · S/N 17273190N6320RGehr Garner J · Eustis, FLS/N 172RG0163N6323ESwedish Flying Couching LLC · Franklin, WIBuilt 1959 · S/N 46423N63251Christiansen Aviation LLC · Wilmington, DES/N 172S10783N6325DCox Ronnie L · Whitesburg, GABuilt 1979 · S/N 17272717N6326EKevin Formica Inc · Boca Raton, FLS/N 17272006N6326FAirtime Holdings LLC · Charleston, SCBuilt 1979 · S/N 17273191N63273Hlavinka Terrance J · East Bernard, TXBuilt 1981 · S/N 17275411N63279P & H Air Inc · Overland Park, KSBuilt 1981 · S/N 17275412N6327ESpiro Brian F · Wonder Lake, ILBuilt 1959 · S/N 46427N6329EFeigl Frederick D · Dallas, TXBuilt 1959 · S/N 46429N632AAAerospring Leasing LLC · Wasilla, AKBuilt 2025 · S/N 172S13374N632CRChristiansen Aviation LLC · Wilmington, DEBuilt 2014 · S/N 172S11458N632LAJoy Air LLC · Scottsdale, AZBuilt 2023 · S/N 172S13109N632SPWestosha Flying Club Inc · Kenosha, WIBuilt 2000 · S/N 172S8627N6330ECollins Anthony W · Bowdoinham, MEBuilt 1959 · S/N 46430N6330VLegacy Lsa LLC · Lubbock, TXS/N 172RG0628N63312Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1981 · S/N 17275419N6332DBlue River Aviation LLC · Wasilla, AKBuilt 1979 · S/N 17272720N6332ERampani Joe J · Sullivan, MOBuilt 1959 · S/N 46432N6333FMattuski Joseph C Jr · Parker, COFirst renewal noticeBuilt 1979 · S/N 17273193N6334ESrygley Donald E · Muscle Shoals, ALBuilt 1959 · S/N 46434N63352Carter Flygare Inc · Sacramento, CABuilt 1981 · S/N 17275425N6335ECorro Lee A · Holden, MES/N 46435N63366Purdue Aviation LLC · West Lafayette, INBuilt 1981 · S/N 17275426N6336VKman LLC · Kalispell, MTBuilt 1980 · S/N 172RG0632N63371Flight Training Aircraft LLC · Wilmington, DEBuilt 2008 · S/N 172S10813N6337DHomerace Inc DBA · Tulsa, OKBuilt 1979 · S/N 17272723N6337VFirelight Ventures LLC · Fuquay Varina, NCBuilt 1980 · S/N 172RG0633N6337XUnique Educational Experiences Inc · Long Beach, CABuilt 2008 · S/N 172S10812N6338DEdb Air Inc · Wilsonville, ORBuilt 2008 · S/N 172S10814N6338EBarber Theodore C Trustee · Spanish Fork, UTBuilt 1959 · S/N 46438N6338FRaritan Valley Flying School · Princeton, NJBuilt 1979 · S/N 17273195N6339DContrails II Inc · Kerrville, TXS/N 17272725N6339EJudge Nathan E · Coeur D Alene, IDBuilt 1959 · S/N 46439N633BCOneal Brittany H · Palestine, TXS/N 17274633N633CRChristiansen Aviation LLC · Wilmington, DEBuilt 2014 · S/N 172S11459N633MTMajor Air LLC · Charleston, SCBuilt 1976 · S/N 17267904N633NDAyah Investments LLC · Kent, WABuilt 2013 · S/N 172S11292N633WGWings Of Grace Ministries Inc · Melbourne, FLBuilt 1968 · S/N 17256670N63405Christiansen Aviation LLC · Wilmington, DEBuilt 2008 · S/N 172S10849N6340EAdams Mandy Reed · New Braunfels, TXBuilt 1959 · S/N 46440N63419Aviation Training LLC · Wilmington, DEBuilt 2004 · S/N 17281224N6341EHansen'S Garage LLC · Spring City, UTS/N 46441N6341JAbriam Darryl Mods B · Jacksonville, FLBuilt 1980 · S/N 17273865N6341TGoose Leasing LLC · Ashburn, VABuilt 2008 · S/N 172S10843N6342BFargo Jet Center LLC · Fargo, NDBuilt 2008 · S/N 172S10842
Back to AD 90-06-03 R1