Registered aircraft · 4,242

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

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:89-24-01-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:89-24-01-R1') ORDER BY n_number

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:89-24-01-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:89-24-01-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.

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:89-24-01-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:89-24-01-R1')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N5395VCortez Flying Service Inc · Cortez, COBuilt 1975 · S/N 21060930 N53AUJoachim Peter · Grafton, WIBuilt 1974 · S/N 340-0356 N53WTRock House LLC · Keizer, ORBuilt 1980 · S/N 414A0533 N5401AHeadon Richard · Chino Hills, CABuilt 1979 · S/N 21063414 N5401XBarbera Frank M · Edgewood, NMBuilt 1980 · S/N U20605717 N5404WBas Part Sales LLC · Greeley, COBuilt 1981 · S/N P21000683 N5405AN5405a LLC · Beverly Hills, CABuilt 1985 · S/N P21000852 N5409GRichland Aviation Inc · Sidney, MTS/N 404-0028 N5409YLee Christopher · Katy, TXBuilt 1980 · S/N 21064198 N540CEEverel Airborne LLC · Sandia Park, NMBuilt 1985 · S/N P21000853 N540NEAirswiss Inc · Wilmington, DEBuilt 1984 · S/N 402C0809 N5416UU S Department Of Agriculture · College Station, TXBuilt 1984 · S/N 21064890 N5416YKer Holdings LLC · Henderson, NVBuilt 1980 · S/N 21064199 N5417YFeldner Mark A · Schererville, INBuilt 1980 · S/N 21064200 N541CMAero Parts LLC · Roselle, ILS/N 340-0338 N5421JPeruzzi John DBA · Los Angeles, CABuilt 1976 · S/N 340A0108 N5424AFudurich David E · Goleta, CABuilt 1979 · S/N 21063428 N5424UWsol Michael P DBA · Huntington Beach, CABuilt 1979 · S/N U20605287 N5425AValiair Ltd Co Trustee · Casper, WYBuilt 1979 · S/N 21063429 N5426CVirginia Air Inc · Roanoke, VABuilt 1979 · S/N 21063749 N542CGulf States Financial Services · Lafayette, LAS/N 21063919 N542EBSvoboda Erik S · Mentor, OHBuilt 1981 · S/N 21064351 N542EMRw Air LLC · Boerne, TXBuilt 1980 · S/N P21000581 N542MNKeeler Aviation LLC · Plattsmouth, NEFirst renewal noticeBuilt 1976 · S/N 340A0109 N5430AAdams Hay Farms LLC · Cedar City, UTBuilt 1979 · S/N 21063433 N5432JSouthampton Wing LLC · Southampton, NYBuilt 1976 · S/N 340A0110 N5432MWorthington Loren D · Caldwell, IDBuilt 1972 · S/N 340-0033 N5434ASteele Group Insurance Agency Inc · Eugene, ORBuilt 1979 · S/N 21063436 N5436UNewsom William Joel III · Roswell, GAS/N 21064892 N5439CLopez Hugo E · Mcallen, TXFirst renewal noticeBuilt 1979 · S/N 21063755 N543BCRoeloffs Arie · Wendell, IDBuilt 1973 · S/N 414-0474 N543DGrantham Ray · Sevierville, TNBuilt 1984 · S/N 340A1805 N543EMPacific Air Flight School LLC · Long Beach, CABuilt 1978 · S/N 21063054 N543VWich Robert · Norfolk, VABuilt 1995 · S/N EA-581 N5446GCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1979 · S/N 340A0685 N5447ASchmidt Aaron B · Auburn, ALBuilt 1985 · S/N P21000855 N5453JC L Flight Associates LLC · Bakersfield, CAS/N 340A0111 N5454XKair Aviation · Parkland, FLS/N 340A1512 N5456YWings As Eagles LLC · Wilmington, DES/N 21064211 N5457AGoebel Joseph · Palos Verdes Est, CABuilt 1985 · S/N P21000856 N5464VLivingood Richard A · Tucson, AZS/N 21060955 N5467APiedmont Air Services LLC · Helena, MTBuilt 1979 · S/N 21063454 N5469XTechaero 210 LLC · Healdsburg, CABuilt 1980 · S/N P21000507 N547CHoch Jeffrey · Seattle, WABuilt 2003 · S/N 0484 N547EMWolcott John · Peoria, AZBuilt 1979 · S/N P21000271 N5482CSantiago Robert S · Torrance, CABuilt 1979 · S/N 21063764 N5484JCaba Joseph · Covington, LAS/N 310R0282 N548GAHyannis Air Service Inc · Hyannis, MABuilt 1982 · S/N 402C0653 N5490AN5490a LLC · Rutherfordton, NCBuilt 1979 · S/N 21063467 N5495VPhillips Ruffin P Jr · Lexington, NCBuilt 1975 · S/N 21060964

Back to AD 89-24-01 R1