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.

N24CVPacific Air Flight School LLC · Long Beach, CABuilt 1977 · S/N 17270186N24GVBoyd Aviation LLC · Nashville, TNBuilt 1975 · S/N 17265760N24KKFlying High Again LLC · Mt Juliet, TNBuilt 1975 · S/N 17266333N24LTPinestate Aviation LLC · Glenburn, MEBuilt 1981 · S/N 17275466N24SGVogel Scott A · Dewey, AZS/N 29764N2500LRice Nancy Kay · Leesburg, TXBuilt 1966 · S/N 17255700N2500XHolloway James H · Merritt Island, FLBuilt 1962 · S/N 17249800N2501ULarkin Edmund V · Bogart, GABuilt 1963 · S/N 17250101N2502UChristensen Alan B · Murphysboro, ILBuilt 1963 · S/N 17250102N2502YSkinner Norman D · Osceola, IABuilt 1965 · S/N 17253227N2503ARegistered aircraftS/N 17249930N2503YGutierrez Gilberto · Lindsay, CAS/N 17249803N2504LRogers Carol J · Hampshire, ILBuilt 1966 · S/N 17255704N2505LCannon Jason P · La Verne, CABuilt 1966 · S/N 17255705N2505YGauges Green LLC · Euless, TXS/N 17249805N2506USterling John A · Port Lavaca, TXBuilt 1963 · S/N 17250106N2506YTouching Clouds LLC · Bridgeview, ILBuilt 1962 · S/N 17249806N2507YGap Mountain Development LLC · Jaffrey, NHBuilt 1962 · S/N 17249807N2508YWarren Jerry L · Medford, ORS/N 17249808N2509LSchufeldt Lawrence H · North Platte, NEBuilt 1966 · S/N 17255709N2509USnyder Mari A · Brighton, COBuilt 1963 · S/N 17250109N2509YAgha-Khan Sikander B · Carolina Shores, NCBuilt 1962 · S/N 17249809N250AUPeregrine Howard Partners II Lp · New Orleans, LABuilt 2024 · S/N 172S13265N250RAReynolds Darryl G · Wills Point, TXFirst renewal noticeBuilt 1975 · S/N 17266043N250SUOklahoma State University · Stillwater, OKBuilt 2016 · S/N 172S11675N250YZAtp Aircraft 2 LLC · Wilmington, DEBuilt 2015 · S/N 172S11608N25110Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13287N25111Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13290N25112Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13293N25113Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13296N25114Career Track 3 LLC · Wilmington, DEBuilt 2025 · S/N 172S13298N25115Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13299N25116Career Track 3 LLC · Wilmington, DEBuilt 2025 · S/N 172S13300N2511798x LLC · Caddo Mills, TXBuilt 1970 · S/N 17259514N25118Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13302N2511LDmcflight LLC · Boynton Beach, FLS/N 17255711N25121Career Track 3 LLC · Wilmington, DEBuilt 2025 · S/N 172S13306N25122Career Track 3 LLC · Wilmington, DES/N 172S13309N25123Career Track 3 LLC · Wilmington, DEBuilt 2025 · S/N 172S13312N25126Career Track 3 LLC · Wilmington, DEBuilt 2025 · S/N 172S13313N25129Career Track 3 LLC · Wilmington, DEBuilt 2025 · S/N 172S13319N2512UNative Sons Aviation LLC · Lake Placid, FLBuilt 1963 · S/N 17250112N25130Career Track 3 LLC · Wilmington, DEBuilt 2025 · S/N 172S13320N25132Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13321N25135Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13327N25136Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13330N25139Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13333N2513LDahlberg James C · Ogilvie, MNBuilt 1966 · S/N 17255713N2513YWilson Hubert Ernest · Gustavus, AKBuilt 1962 · S/N 17249813N25141Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13336
Back to AD 90-06-03 R1