Registered aircraft · 5,440

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:95-26-15-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:95-26-15-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:95-26-15-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:95-26-15-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:95-26-15-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:95-26-15-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.

N340EEFoley Mark R · Northwood, NHBuilt 1981 · S/N 340A1225 N340ELBaas Brian J · Cambridge, MNBuilt 1980 · S/N 340A1004 N340EMBiotech Aviation LLC · Rio Rancho, NMBuilt 1982 · S/N 340A1516 N340EPSouth Bay Aviation LLC · Virginia Beach, VABuilt 1980 · S/N 340A1013 N340ERSanchez Rogelio · San Diego, CABuilt 1982 · S/N 340A1529 N340ESPlane Convenient LLC · Canton, OHBuilt 1978 · S/N 340A0505 N340EZRidley Benjamin · Jamesville, NYBuilt 1976 · S/N 340A0118 N340FCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1976 · S/N 340A0044 N340FAIn Flight Dynamics LLC · Kirtland, OHS/N 340A0527 N340FFMiller Brothers Aviation LLC · Lebanon, PABuilt 1978 · S/N 340A0495 N340FJBurris D Rob Trustee · Tucson, AZBuilt 1976 · S/N 340A0060 N340FKMichelesaire Inc · Wilmington, DEBuilt 1980 · S/N 340A1007 N340FMVogel Mark E · Orange City, IABuilt 1980 · S/N 340A1032 N340FPSeabury John L · Erie, COS/N 340A0298 N340FRS&S Sky LLC · Thatcher, AZBuilt 1976 · S/N 340A0039 N340GDurango Air LLC · Portland, ORBuilt 1980 · S/N 340A1006 N340GBMbw Aviation LLC · Bay City, MIS/N 340A0618 N340GCShupe David L · Dayton, NVS/N 340A-0369 N340GGMarlowe Clifford Gray · Maxwelton, WVBuilt 1979 · S/N 340A0916 N340GKRiv Desert Sun LLC · Phoenix, AZBuilt 1979 · S/N 340A0625 N340GMElbitamerica Inc · Merrimack, NHBuilt 1976 · S/N 340A0202 N340GSRelevance Capital Management LLC · Brentwood, TNBuilt 1972 · S/N 340-0183 N340GTWow-We Wings LLC · Pawleys Island, SCBuilt 1981 · S/N 340A1249 N340GWThree Rivers Limousine Service Inc · Pittsburgh, PABuilt 1979 · S/N 340A0706 N340HCPropjet 210 Aviation Inc · Windsor, CAS/N 340A0638 N340HESouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1981 · S/N 340A1503 N340HGVan Haitsma Kelly · Fort Worth, TXBuilt 1973 · S/N 340-0228 N340HWHartung Stefan · Greenville, SCBuilt 1976 · S/N 340A0265 N340JOkla-Tex Energy Corp · Tyler, TXS/N 340-0171 N340JCS O W Aviation LLC · Crystal River, FLBuilt 1979 · S/N 340A0801 N340JDWescott Aviation LLC · Prospect, KYBuilt 1972 · S/N 340-0100 N340JFSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1978 · S/N 340A0451 N340JJAmnr LLC · Shawnee, OKS/N 340-0040 N340JLLechman Joseph · Agoura Hills, CABuilt 1982 · S/N 340A1543 N340JMHunter Pilot Services LLC · Hollister, CABuilt 1978 · S/N 340A0640 N340JPOlive Aviation LLC · Anchorage, AKBuilt 1973 · S/N 3400232 N340JQLiu Qi · Saratoga, CAS/N 340A0279 N340JSAsher Kenneth Edward · Durango, COBuilt 1979 · S/N 340A0661 N340KRegistered aircraftBuilt 1979 · S/N 340A0792 N340KCRegistered aircraftBuilt 1980 · S/N 340A0959 N340KGAero Vulcan LLC · Moody, ALBuilt 1982 · S/N 340A1505 N340KSDavieation III LLC · St Simons Is, GABuilt 1981 · S/N 340A1501 N340KTN44fu LLC · Oklahoma City, OKBuilt 1977 · S/N 340A0356 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

Back to AD 95-26-15 R1