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.

N7246QHaines Anne K · Ligonier, PABuilt 1972 · S/N 17260546N7246TKruger Bruce W · Gustavus, AKS/N 46846N7247TNelson Harold G · Pendleton, ORBuilt 1959 · S/N 46847N7248AMoore Greg J · Bakersfield, CAS/N 29348N7248QEricson Steven L · Dorris, CABuilt 1972 · S/N 17260548N7248TStormont Dylan · Xenia, OHS/N 46848N7249GTate Donald E · Jonesburg, MOBuilt 1970 · S/N 17258949N7249QTrailgate Tailgate Systems Inc · Belle Vernon, PABuilt 1972 · S/N 17260549N724BF5904 Msl LLC · Tahoe City, CABuilt 2018 · S/N 172S12192N724CTWarner David A · Carbondale, ILBuilt 1963 · S/N 17251105N724EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2023 · S/N 172S13026N724LCDixon Jody S · Chancellor, ALBuilt 1966 · S/N 17254599N724LULiberty University Inc · Lynchburg, VABuilt 2024 · S/N 172S13206N724PGL&W Leasing LLC · Murfreesboro, TNBuilt 1998 · S/N 17280613N724SPCandace A Larned Enterprises Inc · Long Beach, CABuilt 2000 · S/N 172S8658N724TJPellow James A · Dixie, WAS/N 17254147N724TMMorcom Aviation Services Inc DBA · Everett, WABuilt 1974 · S/N 17262971N724TXStratus Aviation LLC DBA · Vacaville, CABuilt 1974 · S/N 17263381N7250QSale Reported · Crystal, MNSale reported, pending cancellationBuilt 1972 · S/N 17260550N7251AHoward F Bret · Albany, OHBuilt 1956 · S/N 29351N7251QGarcia Crystal M · Brownsville, ORBuilt 1972 · S/N 17260551N7252ABarbaro Aaron J · Marcellus, NYBuilt 1956 · S/N 29352N7252GLeaders Flying Service LLC · Clear Lake, MNBuilt 1970 · S/N 17258952N7252QRobbins Aviation LLC · Scottsbluff, NEBuilt 1972 · S/N 17260552N7253GOne Mile LLC · Canton, GABuilt 1970 · S/N 17258953N7253QHarry'S Hawks · Wells, MNBuilt 1972 · S/N 17260553N7254AStiffey Jason J · Port Orchard, WAS/N 29354N7254QRegistration Pending · Phoenix, AZRegistration pendingBuilt 1972 · S/N 17260554N7255ANunziato Anthony J · Tewksbury, MABuilt 1956 · S/N 29355N7255QSierra Sky Aviation LLC · Kalispell, MTS/N 17260555N7257AJones William Shane · Griffin, GABuilt 1956 · S/N 29357N7257EAerospring Leasing LLC · Wasilla, AKBuilt 1999 · S/N 17280760N7257QSmith Henry C III · Essexville, MIBuilt 1972 · S/N 17260557N7257TJet & Rotor Aviation LLC · Sacramento, CABuilt 1999 · S/N 17280787N7257ZPrivate Pilot Aircraft Rentals LLC · Sanibel, FLBuilt 1999 · S/N 17280783N7258International Air Services Inc Trustee · Carson City, NVBuilt 1980 · S/N 172RG-0508N7258ANguyen Anthony V · Keyser, WVBuilt 1956 · S/N 29358N7258RMoynihan Daniel P · Hernando Beach, FLS/N 17280981N7258TAutry Stephen W · Durango, COBuilt 1959 · S/N 46858N7259AHalladay Roy · Erie, COS/N 29359N7259QForbes Gregory Allan · Lowell, MIBuilt 1972 · S/N 17260559N7259THarrington Everett Dean · Council, IDBuilt 1959 · S/N 46859N725BBScenic Concepts LLC · La Crosse, WIBuilt 1976 · S/N 17267802N725BKAmerican Patrols Inc · Midland, TXBuilt 1971 · S/N 17259821N725ECDraco Flight School Inc · Chino, CABuilt 1972 · S/N 17260842N725LCReeves Jerry H · Whitesburg, GABuilt 1964 · S/N 17251919N725LULiberty University Inc · Lynchburg, VABuilt 2024 · S/N 172S13209N725LVAia Echo LLC · Henderson, NVBuilt 2021 · S/N 172S12748N725PGPoplar Grove Airmotive Inc · Poplar Grove, ILBuilt 1998 · S/N 172S8009N725RJWilliams Sol F · Jacksonville, FLBuilt 1971 · S/N 17260254
Back to AD 90-06-03 R1