Registered aircraft · 3,961

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:87-21-02-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:87-21-02-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:87-21-02-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:87-21-02-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:87-21-02-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:87-21-02-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.

N340KYE Lite Aviation Inc · Cordova, TNFirst renewal noticeBuilt 1978 · S/N 340A0622 N340L310 Air Ltd · Seville, OHBuilt 1978 · S/N 340A0518 N340LBSteed Dan E Trustee · Groom, TXBuilt 1972 · S/N 340-0053 N340LEThree Forty LLC · Saint George, UTS/N 340A0233 N340LHAviation Limited Holdings LLC · Albuquerque, NMBuilt 1977 · S/N 340A0409 N340LLFrank Leasing LLC · Scottsbluff, NES/N 340A1228 N340LMCrawford William K · Indianapolis, INBuilt 1978 · S/N 340A0478 N340LQDownwind Flight LLC · San Antonio, TXBuilt 1976 · S/N 340A0020 N340LZWestern Radiation Oncology Assoc Pc · Great Falls, MTFirst renewal noticeBuilt 1975 · S/N 340-0537 N340MBRecon Real Estate Consultants Inc · El Paso, TXBuilt 1982 · S/N 340A1508 N340ME58gp Wing LLC · Wilmington, DEBuilt 1978 · S/N 340A0550 N340MFMerrill Farms · Corral De Tierra, CABuilt 1982 · S/N 340A1542 N340MGN340mg LLC · Highlands Ranch, COS/N 340A0769 N340MHFlying High Llp · Williston, NDBuilt 1981 · S/N 340A-1214 N340MJAll-Star Executive Aviation Inc · Pomona, CABuilt 1993 · S/N 340A1521 N340MKMilbern Aircraft Corporation · Brooklyn, NYBuilt 1982 · S/N 340A1541 N340MLD & L Airlines LLC · West Chester, OHBuilt 1979 · S/N 340A0729 N340MMRegistered aircraftS/N 340A0238 N340MPPaxell Aviation LLC · Springdale, ARS/N 340A0359 N340MSSprings1781 LLC · Colorado Springs, COBuilt 1979 · S/N 340A0760 N340MWInternational Air Services Inc Trustee · Carson City, NVS/N 340A0101 N340MYAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1979 · S/N 340A-0906 N340NN-Number Inc · Santa Fe, NMBuilt 1982 · S/N 340A1540 N340NGCentral Virginia Aviation Inc · Petersburg, VAS/N 340-0042 N340PCDouble J Aviation LLC · Burlington, WIBuilt 1979 · S/N 340A0962 N340PFSharon Leasing Co · Ludington, MIBuilt 1977 · S/N 340A0225 N340PJPremier Jets Inc · Hillsboro, ORBuilt 1975 · S/N 340-0539 N340PLSummit Aircraft Sales LLC · Akron, OHS/N 340-0546 N340PPRegistered aircraftBuilt 1979 · S/N 340A0747 N340PRFly Yawa Aviation LLC · Statesboro, GABuilt 1976 · S/N 340A0123 N340PTMach Air LLC · Townsend, GABuilt 1972 · S/N 340-0014 N340PWValiair Limited Co Trustee · Casper, WYS/N 340A0933 N340RASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1976 · S/N 340A0038 N340RBCorcoran Kim C Trustee · Burrton, KSBuilt 1978 · S/N 340A0498 N340RDDeaton Courtney · London, KYS/N 340-0019 N340RFN340rf LLC · Denver, COBuilt 1976 · S/N 340A0212 N340RGSteggs Garret E · Edmond, OKBuilt 1973 · S/N 340-0239 N340RHMy Toy Box Inc · Debary, FLBuilt 1972 · S/N 340-0086 N340RJStohr Jeffry M · Aberdeen, SDS/N 340A0273 N340RPMeister Scott R · Skillman, NJBuilt 1979 · S/N 340A0733 N340RRCustom Data Engineering Inc · Phoenix, AZS/N 340-0107 N340RSWestermeyer Holdings LLC · Longville, MNBuilt 1977 · S/N 340A0371 N340SBStarlight Express LLC · Bellevue, WABuilt 1979 · S/N 340A0724 N340SDRegistration Pending · Kaukauna, WIRegistration pending, canceledS/N 340A0408 N340SGN340sg Leasing LLC · Sheridan, WYBuilt 1980 · S/N 340A0973 N340SHHenderson Scott · Tucson, AZBuilt 1978 · S/N 340A0548 N340STSchlabach Herman · Belton, TXBuilt 1978 · S/N 340A0528 N340SUDm Air Ltd · Newark, OHS/N 340A0979 N340SVQuetzal Aviation Corp · Washington, DCBuilt 1980 · S/N 340A1003 N340TARmb Leasing Inc · Dover, DEBuilt 1979 · S/N 340A0648

Back to AD 87-21-02 R1