Registered aircraft · 21

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

N163JRDodson International Parts Inc · Rantoul, KSS/N 3057 N211LMPark Avenue Aircraft Trust LLC Trustee · Dover, DEBuilt 1984 · S/N 3024 N213TSBank Of Utah Trustee · Salt Lake City, UTBuilt 1983 · S/N 3013 N304CTAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 1985 · S/N 3044 N349CRAviation Resource Group Inc · Fort Lauderdale, FLS/N 3049 N356CRAviation Resource Group Inc · Fort Lauderdale, FLS/N 3056 N418PPGranger J Weldon · Houston, TXBuilt 1985 · S/N 3041 N45WLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 3004 N480LALuxury Aero Collection LLC · Scottsdale, AZBuilt 1983 · S/N 3003 N515LFAdelante Aviation LLC · Leawood, KSBuilt 1986 · S/N 3052 N600GA601 Holdings LLC · Las Vegas, NVBuilt 1985 · S/N 3046 N601HGug LLC · Wilmington, DES/N 3061 N601JGChallenger Aircraft Charters LLC · Newport Beach, CABuilt 1983 · S/N 3006 N601RCRaytheon Co · Tucson, AZBuilt 1986 · S/N 3055 N624EMGlobal Aircraft Trust Inc Trustee · Cheyenne, WYS/N 3039 N657GFChallenger 601 - 3045 Inc · Wilmington, DES/N 3045 N773CLPollard Spares LLC · Roanoke, TXBuilt 1984 · S/N 3032 N807MMPollard Spares LLC · Fort Worth, TXBuilt 1983 · S/N 3014 N824DHPollard Spares LLC · Roanoke, TXBuilt 1985 · S/N 3047 N893TASta Aviation Management · New York City, NYBuilt 1983 · S/N 3016 N951RMSiilats Keith · New York, NYS/N 3042

Back to AD 2019-10-01