Registered aircraft · 264

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

N100RMNs Air Leasing LLC · Wilmington, DES/N 84-23935 N1075BBrown Helicopter Inc · Pensacola, FLBuilt 1986 · S/N 86-24512 N1079GBrown Helicopter Inc · Pensacola, FLS/N 79-23295 N112HCHail Helicopter Holdings-Unit 3 LLC · Tulsa, OKBuilt 1979 · S/N 77-22728 N113BCarson Helicopters Inc · Perkasie, PAS/N 85-24482 N1144CNs Air Leasing LLC · Wilmington, DEBuilt 1984 · S/N 84-23977 N116ACarson Helicopters Inc · Perkasie, PABuilt 1979 · S/N 79-23293 N1209DInternational Defense & Aerospace Group Inc · Glen Mills, PAS/N 80-23482 N121GDAce Aeronautics LLC · Guntersville, ALS/N 82-23701 N121MXAce Aeronautics LLC · Guntersville, ALS/N 83-23839 N121UAAce Aeronautics LLC · Guntersville, ALS/N 83-23899 N121XSAce Aeronautics LLC · Guntersville, ALBuilt 1982 · S/N 82-23660 N125FHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1979 · S/N 79-23307 N13006Department Of Homeland Security · Washington, DCS/N 78-23010 N133THTimberline Helicopters Inc · Sandpoint, IDBuilt 1982 · S/N 81-23616 N134DADillon Aero Inc · Phoenix, AZBuilt 1983 · S/N 83-23846 N13FRyans Rotors LLC · Phoenix, AZBuilt 1986 · S/N 86-24518 N13FHBrainerd Helicopters Inc · Leesburg, FLBuilt 1981 · S/N 79-23353 N152BHBrown Helicopter Inc · Pensacola, FLS/N 82-23667 N153BHBrown Helicopter Inc · Pensacola, FLS/N 79-23277 N154WTCharlotte County Sherrifs Department · Punta Gorda, FLBuilt 1986 · S/N 86-24508 N15LACounty Of Los Angeles · Pacoima, CAS/N 702846 N160AEUnical Air Inc · Arcadia, CAS/N 82-23750 N160AQCormorant Venture LLC · Irvine, CABuilt 1982 · S/N 81-23588 N160BKUnical Air Inc · Arcadia, CABuilt 1983 · S/N 83-23887 N160CDUc Helitanker 1 LLC · Arcadia, CABuilt 1980 · S/N 80-23507 N160DNUnical Defense LLC · City Of Industry, CAS/N 79-23316 N160DQPolar Star Corp · Kalispell, MTBuilt 1979 · S/N 79-23326 N160DUAwh-Bh1 LLC · Westport, CTS/N 79-23339 N160EQPolar Star Corp · Kalispell, MTBuilt 1978 · S/N 78-23004 N160KAUnical Defense LLC · City Of Industry, CAS/N 87-24659 N160LACounty Of Los Angeles Fire Dept Air Operations · Pacoima, CAS/N 702453 N160NTUnical Defense LLC · City Of Industry, CAS/N 83-23917 N160PARegistered aircraftBuilt 1981 · S/N 81-23585 N160XPGrayman Group LLC · Exeter, CABuilt 1985 · S/N 85-24470 N162BHBrown Helicopter Inc · Pensacola, FLS/N 79-23313 N166AJUnical Defense LLC · City Of Industry, CAS/N 86-24571 N166BLUnical Defense LLC · City Of Industry, CAS/N 86-24569 N166BTUnical Defense LLC · City Of Industry, CAS/N 86-24576 N166DFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1983 · S/N 83-23877 N166DPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1980 · S/N 80-23445 N16FHBrainerd Helicopters Inc · Leesburg, FLBuilt 1982 · S/N 81-23618 N179BHBrown Helicopter Inc · Pensacola, FLS/N 79-23325 N17FHBrainerd Helicopters Inc · Leesburg, FLBuilt 1981 · S/N 80-23469 N184AAAircraft Investment Holdings LLC · Enterprise, ALS/N 81-23556 N190LACounty Of Los Angeles Fire Department · Pacoima, CAS/N 702479 N194BHBrown Helicopter Inc · Pensacola, FLS/N 80-23443 N22367Department Of Homeland Security · Washington, DCS/N 82-23670 N233AJPatriot Aviation Inc · Greenville, DEBuilt 1982 · S/N 82-23685 N233SKDepartment Of Homeland Security · Washington, DCS/N 79-23321

Back to AD 2020-22-19