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.

N6595G95 Golf Inc · Greenwood, INBuilt 1980 · S/N 17273609N6596DMcdonald Kevin K · Anchorage, AKBuilt 1979 · S/N 17272885N65994Christiansen Aviation LLC · Wilmington, DEBuilt 1983 · S/N 17275942N6599DBlue Shield Aviation LLC · Saint Petersburg, FLBuilt 1979 · S/N 17272886N659EREmbry-Riddle Aeronautical University Inc · Prescott, AZS/N 172S12541N659SPChristiansen Aviation LLC · Wilmington, DEBuilt 1999 · S/N 172S8064N65DPPilawski Darren · Spring Hill, FLS/N 17257299N65GVDemski Domenic Ross · Woodbridge, CAS/N 17271252N65HFHorizon Flight Center LLC · Chesapeake, VABuilt 2024 · S/N 172S13138N65JAJahawk Leasing LLC · Sugar Grove, ILBuilt 1977 · S/N 17268591N65KDNorthwest Wings LLC · Hillsboro, ORBuilt 1974 · S/N 17264565N65WBMckamey Robert S · Tullahoma, TNBuilt 1966 · S/N 17254426N6600RDoyles Welding Lc · Phillipsburg, KSBuilt 1979 · S/N 172RG0206N6600TJtf Aviation LLC · River Falls, WIBuilt 1962 · S/N 17249906N66010Crane William Jr · Somerville, ALBuilt 2005 · S/N 172S9771N66015Rock Solid Aviation LLC · Lake Charles, LABuilt 1983 · S/N 17275948N66018Executive Aviation LLC · Peoria, AZBuilt 1983 · S/N 17275949N6601HCanby Pilots Club Inc · Canby, MNBuilt 1975 · S/N 17265503N6601KAir Force Academy Aero Club · Usaf Academy, COBuilt 1980 · S/N 17274218N6601RHolmes Donald R · Carlsbad, CABuilt 1979 · S/N 172RG0207N66025Suburban Air Corp · Castro Valley, CAS/N 172S9777N6602DLand Of Liberty LLC · Seminole, FLS/N 17272889N6602HOver The Mountain Aviation LLC · Calera, ALBuilt 1975 · S/N 17265504N66038Landrum Erik G · Austin, TXBuilt 1983 · S/N 17275953N6603AWise Phillip L · Harris, MOBuilt 1956 · S/N 28703N66046Palm Beach Flight Training Corp · Lantana, FLBuilt 2005 · S/N 172S9786N66049Aerosync LLC · Miami, FLBuilt 1983 · S/N 17275954N6604AFlight Club LLC · Dover, DEBuilt 1956 · S/N 28704N6604EFlyn High Aviation LLC · Boynton Beach, FLBuilt 1978 · S/N 17272043N6605AKehoe Troy D · Bridgeport, TXBuilt 1956 · S/N 28705N6605DAlameda Aero Club · Alameda, CABuilt 1979 · S/N 17272892N66068Phoenix East Aviation LLC · Daytona Beach, FLBuilt 2005 · S/N 172S9790N6606AMckenna Terence M · Scotts Valley, CABuilt 1956 · S/N 28706N6606DRegistration Pending · Sturgeon Bay, WIRegistration pendingBuilt 1979 · S/N 17272893N6607AOlson Duane C · Columbus, KSBuilt 1956 · S/N 28707N6607DVero Technical Support Inc · Pensacola, FLBuilt 1980 · S/N 17272894N66083Bravo Zulu Aviation LLC · Torrance, CABuilt 2005 · S/N 172S9938N66084Cummings Steven R Trustee · Wyarno, WYS/N 17275962N66085Bellers Aviation Inc · Fremont, CABuilt 2004 · S/N 172S9768N6608AMarquardt Ashley F · Anchorage, AKBuilt 1956 · S/N 28708N6608DAmericus Flying Club Inc · Americus, GABuilt 1979 · S/N 17272895N6608RBogovich Robert E · Clifton, TXBuilt 1979 · S/N 172RG0210N66090Skyline Solutions Inc · Deland, FLBuilt 1983 · S/N 17275963N66091Ftg Leasing LLC · Watkins, COBuilt 1982 · S/N 17275964N66097Gaskin Greg · Lake Almanor, CABuilt 1983 · S/N 17275965N6609APelon Robert C · Chugiak, AKBuilt 1956 · S/N 28709N6609DCopperhead Environmental Consulting Inc · Paint Lick, KYBuilt 1979 · S/N 17272896N660EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2020 · S/N 172S12543N660JWLearning 2 Fly LLC · Cave Creek, AZBuilt 2005 · S/N 172S9788N660SPRobert Devers Solutions · Hermosa Beach, CABuilt 1998 · S/N 172S8065
Back to AD 90-06-03 R1