Skip to content

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.

N521UWAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 3944 N521VLUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 5651 N5221TPalmer Charles S · Hernando, MSBuilt 1976 · S/N TC-1995 N5227JSbs Partnership · Henderson, NVBuilt 1980 · S/N 340A1036 N522AXBc Aircraft Leasing LLC · Albuquerque, NMBuilt 1988 · S/N 48315 N522GNeu Aviation Maintenance LLC · Benton, LABuilt 1958 · S/N TD-80 N522VLBank Of Utah Owner Trustee · Salt Lake City, UTBuilt 2013 · S/N 5776 N522VRBank Of Utah Trustee · Salt Lake City, UTS/N 1102 N5236MAri Ben Aviator Inc · Fort Pierce, FLBuilt 1978 · S/N ME-21 N523JBJetblue Airways Corp · Long Island City, NYBuilt 2001 · S/N 1506 N523UWAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 3960 N523VLUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 6014 N5245FAex Aviation LLC · Davenport, FLBuilt 1965 · S/N LJ-92 N524JBJetbule Airways Corporation · Long Island City, NYBuilt 2001 · S/N 1528 N524UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 3977 N524VLBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6161 N5256JKamenz Donald R · Mocksville, NCBuilt 1977 · S/N 340A0403 N525TChomchird Jon Attaporn · Centreville, VABuilt 1962 · S/N TC-360 N525VLUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 6332 N526JLJetblue Airways Corp · Long Island City, NYBuilt 2001 · S/N 1546 N526PMMccandless Malinda Sue · Sussex NbFirst renewal noticeBuilt 1973 · S/N TC-1507 N526RRDaytona Hot Cars Inc · Port Orange, FLBuilt 1967 · S/N LJ-263 N526VLWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2015 · S/N 6470 N527DDK&A Advisors LLC Trustee · Wilmington, DEBuilt 1987 · S/N 1040 N527JCGiv Exec Jet LLC · Ithaca, NYBuilt 1991 · S/N 1179 N527JHTugende LLC · Montrose, COBuilt 1979 · S/N 340A0782 N527JLJetblue Airways Corp · Long Island, NYBuilt 2001 · S/N 1557 N527MLMoss Herman D · Centreville, VABuilt 1966 · S/N TE-217 N527TFlying H Enterprises LLC · Smithville, MOBuilt 1964 · S/N TC-576 N527VLWilmington Trust Na Trustee · Wilmington, DEBuilt 2015 · S/N 6705 N5283MPskd Limited LLC · Upland, CABuilt 1978 · S/N ME-25 N528LCSaunders Michael · Argyle, TXBuilt 1963 · S/N TC-509 N529CCC747 LLC · Wilmington, DEBuilt 1969 · S/N TC-1230 N529JBJetblue Airways Corporation · Long Island City, NYBuilt 2001 · S/N 1610 N52JMJetstar Aviation Group LLC · Norlina, NCBuilt 1980 · S/N TC-2309 N52MBRoark Dale L · Cheyenne, OKS/N TE-395 N52SCTaylor Aaron Lee · Salado, TXBuilt 1965 · S/N TC-951 N52STWeicks Aviation LLC9634 · Cedar Falls, IAS/N 340A0696 N52TADowell Thomas · New Smyrna Beach, FLBuilt 1963 · S/N TC-442 N52VBHarral Vaughn R · Prescott Valley, AZBuilt 1964 · S/N TC-560 N530FLBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1153 N530MOsteen Robert S · Port Saint Lucie, FLBuilt 1964 · S/N TC-687 N530XTBank Of Utah Trustee · Salt Lake City, UTS/N 4931 N5316JCocola Gary M · Fresno, CABuilt 1977 · S/N 340A0405 N531JLJetblue Airways Corp · Long Island City, NYBuilt 2001 · S/N 1650 N531MHigh Cotton Aero LLC · Murray, KYBuilt 1978 · S/N 340A0534 N531QRegistered aircraftBuilt 1968 · S/N TC-1141 N531UArizona Air Transport LLC · Mesa, AZBuilt 1966 · S/N TE-104 N5320JCorporate Air Charter Inc · Wilmington, DEBuilt 1977 · S/N 340A0407 N5324JSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 340A0410

Back to AD 95-26-15 R1