Registered aircraft · 29

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

N10112Kc Aviation Stem Inc · Kansas City, MOS/N 193L1064 N104HRXyrec Inc · San Antonio, TXNon-citizen corporation, flight hours not reportedS/N 21525 N140SCOrbital Sciences LLC · Mojave, CABuilt 1974 · S/N 193E1067 N164TSBank Of Utah Trustee · Salt Lake City, UTS/N 21119 N165TSBank Of Utah Trustee · Salt Lake City, UTS/N 21523 N209TRCareer Aviation Co Inc · Wilmington, DEBuilt 1976 · S/N 20994 N2819WDodson International Parts Inc · Rantoul, KSBuilt 1975 · S/N 21057 N281FLInternational Trading Co Of Yukon · Oklahoma City, OKBuilt 1978 · S/N 21455 N289MTRaytheon Co · Ontario, CABuilt 1981 · S/N 22467 N31019Save A Connie Inc DBA · Kansas City, MOBuilt 1974 · S/N 193B-1066 N353PAAersale Inc · Coral Gables, FLS/N 20622 N422BNAntares Aviation LLC · Boca Raton, FLBuilt 1973 · S/N 20735 N438BNAntares Aviation LLC · Boca Raton, FLBuilt 1975 · S/N 21045 N502DADodson International Parts Inc · Rantoul, KSBuilt 1977 · S/N 21304 N615PA2d Aviation Corp · Frisco, TXBuilt 1976 · S/N 21266 N708AAWorld Aviation Services LLC · Medley, FLBuilt 1981 · S/N 22465 N720CKKalitta Charters II LLC · Ypsilanti, MIBuilt 1977 · S/N 21298 N722LALogistic Air Inc · Reno, NVS/N 22992 N724CKKalitta Charters II LLC · Ypsilanti, MIBuilt 1971 · S/N 20383 N726USUSA Jet Airlines Inc · Belleville, MIBuilt 1981 · S/N 22469 N727HLAviation Sales And Charter LLC · Dover, DES/N 22642 N727NKAntares Aviation LLC · Boca Raton, FLBuilt 1979 · S/N 21945 N727USUSA Jet Airlines Inc · Belleville, MIBuilt 1981 · S/N 22470 N727YKFayaka Airways LLC · San Francisco, CANon-citizen corporation, flight hours not reportedS/N 21442 N729CKConair USA Co · Dover, DEBuilt 1982 · S/N 22982 N752DHKalitta Charters II LLC · Ypsilanti, MIBuilt 1981 · S/N 22466 N794AJZero Gravity Corp · Merritt Island, FLBuilt 1976 · S/N 21243 N874AAAntares Aviation LLC · Boca Raton, FLBuilt 1978 · S/N 21386 N91011Orbital Sciences LLC · Mojave, CAS/N 1241

Back to AD 85-06-02