Registered aircraft · 1,110

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:96-18-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:96-18-13') 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:96-18-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:96-18-13')
  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:96-18-13')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:96-18-13')
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.

N348AJE E & K C LLC · New Orleans, LABuilt 1997 · S/N 258334 N351ASRoyal Air Freight Inc · Waterford, MIBuilt 1977 · S/N 146 N351PJPremier Jets Inc · Hillsboro, ORFirst renewal noticeBuilt 1976 · S/N 074 N351TXDodson International Parts Inc · Rantoul, KSBuilt 1977 · S/N 127 N352CKKalitta Charters LLC · Ypsilanti, MIBuilt 1980 · S/N 313 N352EFDodson International Parts Inc · Rantoul, KSBuilt 1992 · S/N 046 N353CKKalitta Charters LLC · Ypsilanti, MIBuilt 1976 · S/N 081 N353HAMpr Aviation LLC · Wilmington, DEBuilt 1986 · S/N 650-0109 N354LQBrunner Aerospace LLC · Georgetown, TXBuilt 1976 · S/N 055 N355CKKalitta Charters LLC · Ypsilanti, MIBuilt 1976 · S/N 062 N355FAE D Santos & & Associates LLC Trustee · Wilmington, DEBuilt 1989 · S/N 258156 N355KCN331us LLC · Hillsboro, ORBuilt 1982 · S/N 490 N355RMLopez Fabio A · Denver, NCBuilt 1982 · S/N 033 N355UALopez Fabio A · Denver, NCBuilt 1984 · S/N 114 N356EJAlliance Aviation Group LLC · Wilmington, DEBuilt 1999 · S/N 258452 N356MANazareth Bay Holdings LLC · Palm Beach Gardens, FLBuilt 1998 · S/N 258373 N357CKKalitta Charters LLC · Ypsilanti, MIBuilt 1980 · S/N 323 N358CKAirnet II LLC · Columbus, OHBuilt 1978 · S/N 210 N35AEAmerican Fidelity Corp Trustee · Dover, DES/N 595 N35AJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1975 · S/N 010 N35LJDelta Bravo LLC · Taylorville, ILBuilt 1979 · S/N 240 N35WLKalitta Charters LLC · Ypsilanti, MIBuilt 1981 · S/N 438 N361KBpcp Falcon N361k LLC · Wilmington, DES/N 83 N361PJPremier Jets Inc · Hillsboro, ORBuilt 1974 · S/N 003 N362PJPremier Jets Inc · Hillsboro, ORFirst renewal noticeBuilt 1976 · S/N 017 N362TWInjury Care Center LLC · Alpharetta, GABuilt 1983 · S/N 650-0011 N365MRDream Aviation LLC · Lawrence, KSBuilt 1985 · S/N 157 N36BLGo Fast Aviation LLC · El Cajon, CABuilt 1994 · S/N 094 N36SPKentucky State Police · Frankfort, KYBuilt 1985 · S/N 577 N370TPPhmi Aviation LLC · Lewes, DEBuilt 1984 · S/N 650-0059 N3712CF900ex LLC · Minneapolis, MNBuilt 1996 · S/N 04 N373DGAttorney Aviation LLC · Dallas, TXBuilt 2001 · S/N 159 N375RC2022 Olivia Av LLC · Austin, TXBuilt 2001 · S/N 258565 N376BLSkyview LLC · Wilmington, DEBuilt 1978 · S/N 376 N376DBae Systems Tss Inc · Mojave, CABuilt 1981 · S/N 465-76 N377CHHalcon Equipment Leasing LLC · Midlothian, TXBuilt 1991 · S/N 220 N378MGDodson International Parts Inc · Rantoul, KSBuilt 1980 · S/N 428 N37BMLas Express Aviation LLC · Las Vegas, NVBuilt 1994 · S/N 096 N37KJBank Of Utah Owner Trustee · Salt Lake City, UTBuilt 1987 · S/N 173 N381CWN650rj LLC · Marshall, MNBuilt 1986 · S/N 650-0111 N383MCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 322 N383MVN383mv LLC · Amarillo, TXBuilt 1999 · S/N 258403 N383TKThk Holdings LLC · Cincinnati, OHBuilt 2004 · S/N 258700 N384PBOvation Jet Parts LLC · Smyrna, DEBuilt 1980 · S/N 384 N385RCTms Global Investments Inc · Naples, FLBuilt 1984 · S/N 117 N386TLTlo Aviation LLC · Ormond Beach, FLBuilt 1990 · S/N 209 N387TSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1997 · S/N 018 N388WA2029 Aircraft Trust 2 LLC Trustee · Davie, FLFirst renewal noticeS/N 27 N389AWAir Gato Enterprises Inc · Clearwater, FLBuilt 1977 · S/N 157 N38MGBay Venture Management LLC · Atlanta, GABuilt 1989 · S/N 009

Back to AD 96-18-13