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.

N955RPBideler Nicholas · Saint Louis, MOBuilt 1979 · S/N TC-2243 N956AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6050 N956EALopez Fabio · Denver, NCBuilt 1976 · S/N 340A-0085 N956FDFederal Express Corp · Memphis, TNBuilt 1998 · S/N 29115 N956JMJam Aviation LLC · Laredo, TXBuilt 1993 · S/N 1223 N956JTJetblue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6791 N957AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6057 N957JBJet Blue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6809 N957MM957mm Inc · Wilmington, DEBuilt 1964 · S/N TC-669 N9582YCastlewood Medical LLC · Dallas, TXBuilt 1962 · S/N TC-359 N958AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6103 N958BXGulfstream 1227 LLC · Lewes, DEBuilt 1993 · S/N 1227 N958FDFederal Express Corp · Memphis, TNBuilt 1989 · S/N 24371 N958JBJetblue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6859 N958MDGko Aviation LLC · Wilmington, DES/N 340A0734 N9594QJhb Leasing LLC · Madison, MNBuilt 1966 · S/N TE-178 N9598YOber John A · Candor, NYBuilt 1962 · S/N TC-365 N959AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6110 N959DCKpp Air LLC · Navasota, TXBuilt 1980 · S/N 340A0942 N959FDFederal Express Corp · Memphis, TNBuilt 1991 · S/N 25133 N959JBJetblue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6903 N95AACoolidge Marvin L · Newberg, ORBuilt 1959 · S/N TD-256 N95FBSouthern Wings LLC · Shreveport, LABuilt 1964 · S/N TC-640 N95FLWolfenden Enterprises Inc · Vero Beach, FLBuilt 1973 · S/N TC-1625 N95KCTailwinds Flying LLC · Merritt Island, FLS/N TE-203 N95PTFinkelstein Robert S · Palm Beach Gardens, FLBuilt 1980 · S/N TC-2346 N95RDSwair LLC · Denver, COBuilt 1965 · S/N TC-827 N95SDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1971 · S/N LM-125 N95SATurbo Lease LLC · Miami, FLS/N 340B-345 N95SHReady Aim Flyer LLC · New Castle, DEBuilt 1957 · S/N TD-21 N95WAAlpine Aviation Inc · Provo, UTBuilt 1968 · S/N U-6 N9606YWeber David J · Waller, TXBuilt 1962 · S/N TC-368 N9607RJohnston Bradley G · Ossining, NYBuilt 1959 · S/N TD-290 N9608RB2 West Corporation · Winona, MNBuilt 1959 · S/N TD-291 N960AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6125 N960FDFederal Express Corp · Memphis, TNBuilt 1992 · S/N 25593 N960JAce Maker Aviaiton LLC · San Rafael, CABuilt 1961 · S/N TC-170 N960JSJordgrant1521 LLC · Santa Monica, CABuilt 2004 · S/N 1521 N960LSNewport Executive Transportation Inc · Las Vegas, NVBuilt 1990 · S/N 1135 N9616RPray Aviation Inc · Augusta, KSS/N TD-295 N9618YBrant Owen D · Delta Junction, AKBuilt 1962 · S/N TC-373 N961AVWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 3961 N961JTJetblue Airways Corp · Long Island City, NYBuilt 2016 · S/N 6930 N962JTJetblue Airways Corp · Long Island City, NYBuilt 2016 · S/N 6988 N9634RMission Flight Academy · Yucaipa, CABuilt 1960 · S/N TC-4 N963CAAc Spe 7 LLC · Orlando, FLBuilt 2001 · S/N 32381 N964CNational Test Pilot School · Mojave, CABuilt 1981 · S/N 465-66 N964FDFederal Express Corp · Memphis, TNBuilt 1990 · S/N 24884 N964JTJetblue Airways Corp · Long Island City, NYBuilt 2016 · S/N 7018 N965BWIkarus Aviation LLC · Salt Lake City, UTBuilt 1979 · S/N TC-2286

Back to AD 95-26-15 R1