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.

N3959GUniversal Aviation LLC · Decatur, ARS/N 340A0243 N395AWIntercoastal Aviation · Fort Lauderdale, FLBuilt 1997 · S/N 549 N395CMCargo Aircraft Management Inc · Wilmington, OHBuilt 1992 · S/N 25447 N395DZDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 9126 N395UPCargo Aircraft Management Inc · Wilmington, OHBuilt 1998 · S/N 29229 N3960GLubard Stephen C · Woodland Hills, CAS/N 340A0244 N3963GKohsel Aviation LLC · Holland, MIS/N 340A0246 N396CMCargo Aircraft Management Inc · Wilmington, OHBuilt 1991 · S/N 25195 N396DNDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 9128 N396NSAviation Sales Associates LLC · Costa Mesa, CABuilt 1999 · S/N 1395 N396UPUnited Parcel Service Co · Louisville, KYBuilt 2010 · S/N 40364 N397ACTvpx Trust Co LLC Trustee · North Salt Lake, UTS/N 2982 N397AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1988 · S/N 24035 N397DFolse Michael John · San Jose, CABuilt 1968 · S/N TC-1109 N397DNDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 9176 N397JJAvion LLC · Birmingham, ALBuilt 1998 · S/N 1354 N397UPUnited Parcel Service Co · Louisville, KYBuilt 2010 · S/N 40363 N3980GGoods Thomas Jr · Romulus, MIS/N 340A0252 N3981GSilver David S · Brookings, ORS/N 340A0253 N3983GBank Of Utah Trustee · Salt Lake City, UTBuilt 1977 · S/N 340A0255 N398AVAircol 6 Statutory Trust · Wilmington, DEBuilt 2009 · S/N 3988 N398DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2020 · S/N 9360 N399CLBeta Fleet LLC · South Burlington, VTBuilt 1996 · S/N 340B-399 N399CZN399cz LLC · Milwaukee, WIBuilt 1969 · S/N U-91 N399MCRegistered aircraftBuilt 1975 · S/N TC-1852 N399MTBank Of Utah Trustee · Salt Lake City, UTS/N 29741 N39AVBlackbird Jet LLC · Boca Raton, FLBuilt 1989 · S/N 1113 N39DDLarson Danny O · Palmer, AKBuilt 1973 · S/N 340-0246 N39PRAeroplanes LLC · Cary, NCBuilt 1965 · S/N TE-23 N39TNDenaina Leasing Agency LLC · Anchorage, AKBuilt 1968 · S/N U-2 N39UBAmeriflight LLC · Dallas, TXS/N UB-39 N3DFTaurman Keith L · Virginia Beach, VABuilt 1965 · S/N LJ-36 N3ELTwo If Buy LLC · Nashua, NHBuilt 1978 · S/N 340A0525 N3HERidgemont Real Estate Inc · Huntington Woods, MIBuilt 1974 · S/N TC-1710 N3HKInternational Air Services Inc Trustee · Carson City, NVBuilt 1975 · S/N 340-0538 N3LNAllen Jeffrey W · Crestwood, KYBuilt 1973 · S/N 340-0301 N3PFTuinstra Aaron C · Marinette, WIBuilt 1962 · S/N TC-296 N3SUJenkins David G · Grantville, GABuilt 1965 · S/N TE-21 N3THHayden Charles J III · Rhome, TXBuilt 1967 · S/N TC-1034 N3WJLlorca Carlo A · Naples, FLBuilt 1974 · S/N TC-1713 N3XBMonument Aviation LLC · North Chesterfield, VABuilt 1967 · S/N LJ-234 N4001SLeckonby David · Waterford, NYS/N TC-1817 N400AJMilberg Falcon Express LLC · Knoxville, TNBuilt 1990 · S/N 1129 N400APZoie Air LLC · Fort Lauderdale, FLBuilt 1974 · S/N 340-0345 N400BLBuilding Busters Demolition & Excavation Corp · Saint Louis, MOBuilt 1962 · S/N TC-319 N400CAGroundloop Mafia LLC · Desha, ARBuilt 1974 · S/N TC-1727 N400FJPtj Associates LLC · South Pasadena, CABuilt 2002 · S/N 1494 N400JXUmb Bank Na Trustee · Salt Lake City, UTBuilt 2021 · S/N 1602 N400JZJrb Pelican Point Investments LLC · Pompano Beach, FLBuilt 1994 · S/N 1255 N400RLJacobsson Charles A · San Gabriel, CAS/N WA-104

Back to AD 95-26-15 R1