Registered aircraft · 28

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:84-13-03-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:84-13-03-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:84-13-03-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:84-13-03-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:84-13-03-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:84-13-03-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.

N108ADMarquez Padilla Inc · Bonita, CABuilt 1983 · S/N 1080 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 N25VRr Aero LLC · Carson City, NVS/N 1015 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 N600JJCravens Joe Thompson Trustee · Richmond, VAS/N 1022 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 N619TSMavana Heli Support USA Inc · Miami, FLNon-citizen corporation, flight hours not reportedBuilt 1981 · S/N 1019 N624EMGlobal Aircraft Trust Inc Trustee · Cheyenne, WYS/N 3039 N657GFChallenger 601 - 3045 Inc · Wilmington, DES/N 3045 N722DJAir 6 Holdings LLC · Cheyenne, WYBuilt 1982 · S/N 1029 N773CLPollard Spares LLC · Roanoke, TXBuilt 1984 · S/N 3032 N807MMPollard Spares LLC · Fort Worth, TXBuilt 1983 · S/N 3014 N808CHBank Of Utah Trustee · Salt Lake City, UTS/N 1017 N80CKBank Of Utah Trustee · Salt Lake City, UTBuilt 1982 · S/N 1069 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 84-13-03 R1