Skip to content

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.

N6476ZVorlop Robert W · Delray Beach, FLBuilt 1982 · S/N EA-311 N6479NSouth Aero LLC · Albuquerque, NMBuilt 1978 · S/N 21063053 N6479YGv Air Inc · Medford, ORBuilt 1981 · S/N 21064399 N647SBHyde Matthew L · Santa Cruz, CABuilt 1982 · S/N 21064743 N6482YSky West Aviation Inc Trustee · Albuquerque, NMS/N 21064400 N6484L6484l LLC · Denver, COBuilt 1982 · S/N EA-313 N6486VVroom Engineering Inc · Tucson, AZBuilt 1984 · S/N T30300311 N6489WReed Michael · Temple, TXBuilt 1981 · S/N P21000785 N6491BTerrill Guy J · Dillon, MTBuilt 1978 · S/N 21062774 N6491HBlue Air 3 LLC · Miami, FLBuilt 1979 · S/N 20700543 N6492BPatno Delviny A · Daniel, WYBuilt 1978 · S/N 21062775 N6492YMiller Gary Lee · Pittsburgh, PABuilt 1981 · S/N 21064404 N6493NEagle Cap Leasing Inc · Enterprise, ORBuilt 1978 · S/N 21063067 N6496NFisher Ranch Corporation · Blythe, CABuilt 1982 · S/N EA-314 N6498VSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1984 · S/N T30300313 N6499NHelgren Quentin C · Oakland, CABuilt 1978 · S/N 21063073 N649LCSmith Aviation LLC · Sitka, AKBuilt 1980 · S/N TJ-304 N64KTKlute Jordan · Omaha, NEBuilt 1976 · S/N 340A0045 N64RPCoe Administrators LLC · Oshkosh, WIBuilt 1978 · S/N TJ-169 N6505N3c3 Aviation Inc · Dania Beach, FLBuilt 1979 · S/N 21063075 N6506VHarper Dreams LLC · New Smyrna Beach, FLBuilt 1976 · S/N 21061633 N6506ZAf Auto Group · San Jose, CABuilt 1981 · S/N U20606301 N6507VBrown Steven K · Tucson, AZBuilt 1982 · S/N EA-309 N65093Seaman Michael V · Kalispell, MTFirst renewal noticeBuilt 1977 · S/N 21061844 N650BDV1vr LLC · Saint Louis, MOBuilt 1979 · S/N 414A0404 N650DBValiair Limited Company Trustee · Casper, WYBuilt 1982 · S/N 414A0853 N650RMAcci Aviation LLC · Conway, ARBuilt 1978 · S/N 414A0031 N65118Stormy Pilots LLC · Saint Thomas, VIBuilt 1982 · S/N TJ-437 N6517APeterson Holding Co · San Leandro, CABuilt 1979 · S/N 21063541 N6519ABreen Jerry P III · Center Point, TXBuilt 1979 · S/N 21063542 N6519NWinged Chariot LLC · Cincinnati, OHBuilt 1982 · S/N EA-319 N651DBJgm Icarus LLC · Centennial, COBuilt 1976 · S/N 340A0089 N6526MDapp Eric M · Corvallis, ORBuilt 1977 · S/N 21061973 N6527PKaci Property Management Inc · Boise, IDBuilt 1978 · S/N P21000186 N6529RN6529r LLC · Merritt Island, FLBuilt 1982 · S/N EA-322 N6529YBbd Lynch Family Lp · Houston, TXS/N 21064421 N6530YDelgado Gonzalez Hector · San Diego, CABuilt 1981 · S/N 21064422 N6531WInternational Air Services Inc Trustee · Carson City, NVBuilt 1981 · S/N P21000791 N6532NN6532n LLC · Sioux Falls, SDBuilt 1978 · S/N 21063088 N65376Sardella Craig J · Gold River, CABuilt 1983 · S/N EA-366 N6538NHaynie Ray G · Auburn, WABuilt 1978 · S/N 21063094 N653JRMosquito Air LLC · Lewes, DEBuilt 1979 · S/N 340A0726 N6542CLeonard Summers · Pleasanton, CABuilt 1980 · S/N 21063913 N6542UMcdade John P · Fraser, COBuilt 1985 · S/N 21064957 N6544YSchwarzenberg Johannes · Helena, MTBuilt 1981 · S/N 21064429 N6546NMitchell Matthew J · Penn Yan, NYBuilt 1978 · S/N 21063102 N6547CJrp Management LLC · Williams, AZBuilt 1980 · S/N 21063915 N654DEDill Brice R · Glendale, AZBuilt 1978 · S/N 310R1428 N6553V44hw LLC · Shreveport, LABuilt 1967 · S/N D-8625 N6553YCenturion Aero LLC · Coos Bay, ORBuilt 1981 · S/N 21064434

Back to AD 89-24-01 R1