Registered aircraft · 909

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:98-05-14-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:98-05-14-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:98-05-14-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:98-05-14-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:98-05-14-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:98-05-14-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.

N6420YFlying Amigos Aviation LLC · Las Cruces, NMBuilt 1981 · S/N 21064370 N6421YHulett Gregory · Las Vegas, NVBuilt 1981 · S/N 21064371 N642DSJgm Aviation LLC · The Woodlands, TXBuilt 1980 · S/N P21000510 N6431NMorton Craig Allister · Toluca Lake, CABuilt 1978 · S/N 21063007 N6431PHhd Aviation LLC · Hamilton, OHBuilt 1978 · S/N P21000182 N6439NSpectraq LLC · Las Vegas, NVBuilt 1978 · S/N 21063015 N643UFRegistered aircraftN-number assigned (import), not yet registeredS/N 21064551 N6440YTamarack Graphics LLC · Salt Lake City, UTBuilt 1981 · S/N 21064380 N6442YPouppeville LLC · Tulsa, OKBuilt 1981 · S/N 21064382 N6443NEwers Richard G · Indio, CABuilt 1978 · S/N 21063019 N6444WBas Part Sales LLC · Greeley, COBuilt 1982 · S/N P210-00781 N6445YRomero Bernard L · Santa Fe, NMBuilt 1981 · S/N 21064385 N6446WRichter Aviation Inc · Maxwell, CABuilt 1981 · S/N P21000782 N6447ACouch Andrew W · Newport Beach, CABuilt 1979 · S/N 21063528 N644VCElder Daniel R · Kalispell, MTBuilt 1979 · S/N P21000249 N6450YAttica Flyers Inc · Lafayette, INBuilt 1981 · S/N 21064390 N6453NUgly Johns Aircraft LLC · Afton, OKBuilt 1978 · S/N 21063028 N6455CPruett Steven H · Midland, TXBuilt 1980 · S/N 21063893 N6459CBallair LLC · Dalhart, TXBuilt 1980 · S/N 21063895 N6466NHagan Joseph · Steward, ILBuilt 1978 · S/N 21063040 N6469NKestrel Aviation LLC · La Center, WABuilt 1978 · S/N 21063043 N646CDRegistered aircraftBuilt 1979 · S/N 21063402 N6470YSkyhigh Enterprises LLC · Holland, MIBuilt 1981 · S/N 21064396 N6476WWill Investments Inc · Englewood, COBuilt 1981 · S/N P21000784 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 N6489WReed Michael · Temple, TXBuilt 1981 · S/N P21000785 N6492YMiller Gary Lee · Pittsburgh, PABuilt 1981 · S/N 21064404 N6493NEagle Cap Leasing Inc · Enterprise, ORBuilt 1978 · S/N 21063067 N6493YNeed To Fly LLC · Yukon, OKBuilt 1981 · S/N 21064405 N6499NHelgren Quentin C · Oakland, CABuilt 1978 · S/N 21063073 N6505N3c3 Aviation Inc · Dania Beach, FLBuilt 1979 · S/N 21063075 N6506GWestern Skyways Inc · Montrose, COS/N 21064406 N6517APeterson Holding Co · San Leandro, CABuilt 1979 · S/N 21063541 N6519ABreen Jerry P III · Center Point, TXBuilt 1979 · S/N 21063542 N6527PKaci Property Management Inc · Boise, IDBuilt 1978 · S/N P21000186 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 N6535YRichardson Jane S · San Angelo, TXS/N 21064424 N6537WSilver Eagle Holdings LLC · Jerome, IDS/N P21000793 N6538NHaynie Ray G · Auburn, WABuilt 1978 · S/N 21063094 N6542CLeonard Summers · Pleasanton, CABuilt 1980 · S/N 21063913 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 N6553YCenturion Aero LLC · Coos Bay, ORBuilt 1981 · S/N 21064434

Back to AD 98-05-14 R1