Registered aircraft · 207

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

N600SCSouth Carolina Law Enforcement Division · Columbia, SCBuilt 2023 · S/N 39119 N612TABlackbird LLC · Irvine, CAFirst renewal noticeBuilt 1974 · S/N 30624 N621FCFlorida Depart Of Agriculture And Consumer Svcs · Tallahassee, FLBuilt 1991 · S/N 35034 N622FCRegistered aircraftN-number assigned, not yet registeredS/N 35048 N624FCFlorida Forest Service - Fp/Ac · Tallahassee, FLBuilt 1993 · S/N 35060 N626FCFlorida Department Of Agriculture And Consumer · Tallahassee, FLBuilt 1995 · S/N 35088 N669HV2plus 1 LLC · Homer, AKBuilt 1974 · S/N 30171 N66HJEcho Foxtrot Holdings LLC · Lewes, DEBuilt 1976 · S/N 30239 N679HHillcrest Aircraft Co · Lewiston, IDBuilt 1974 · S/N 30164 N67TLTurbines Ltd · West Point, NES/N 36166 N681FDChicago Fire Dept · Chicago, ILS/N 36438 N682FDCity Of Chicago Fire Department · Chicago, ILBuilt 2001 · S/N 36279 N689HHillcrest Aircraft Co Inc · Lewiston, IDBuilt 1979 · S/N 30289 N68ECCopter Lease LLC Trustee · Albuquerque, NMBuilt 1968 · S/N 30008 N714BHHelistream Inc · Kalispell, MTBuilt 1979 · S/N 30953 N721AXSalmon River Helicopters Inc · Riggins, IDBuilt 1995 · S/N 36112 N750DMTradehawk International LLC · Ramona, CAS/N 66-16114 N760GESan Diego Gas & Electric Co · San Diego, CABuilt 2022 · S/N 39105 N775BBCopter Lease LLC Trustee · Albuquerque, NMBuilt 1977 · S/N 30252 N77TLFlorida State Guard · Tallahassee, FLBuilt 1995 · S/N 36116 N8056TAdvanced Aviation Technology Enterprises Inc · Arcadia, FLFirst renewal noticeS/N 30501(SW)N811KARogers Helicopters Inc · Fresno, CABuilt 1974 · S/N 30656 N813FKDepartment Of Justice · Fort Worth, TXBuilt 2005 · S/N 36388 N815SSHilcorp Equipment LLC · Anchorage, AKBuilt 1979 · S/N 30950 N816SSHilcorp Equipment LLC · Anchorage, AKBuilt 1982 · S/N 31209 N82WWeyerhaeuser Nr Co · Eugene, ORBuilt 1981 · S/N 31177 N82WPSalt River Pro Agr Imp & Power Dist · Phoenix, AZBuilt 1980 · S/N 31128 N83230Temsco Helicopters Inc · Ketchikan, AKBuilt 1973 · S/N 30560 N8373HEleven 11 Ventures LLC · Helena, MTS/N 5631 N853QAHeli-Consignment Inc · Chicago, ILBuilt 1977 · S/N 30815 N860AR412 Jw Aviation LLC · Dover, DEBuilt 1990 · S/N 36019 N863HBRegistered aircraftAssigned (import), pending cancellationS/N 37044 N87AMAir Methods LLC · Greenwood Village, COBuilt 2003 · S/N 36322 N87LHHill Lawrence E · Marion, MTBuilt 1971 · S/N 30087 N88HVAppomattox Aviation LLC · Santa Fe, NMBuilt 1980 · S/N 31118 N90057Helibase Inc · Cape TownS/N 30500(SW)N90HXHelicopter Express LLC · Chamblee, GABuilt 2019 · S/N 39101 N911HWRogers Helicopters Inc · Fresno, CABuilt 1980 · S/N 31101 N911KWRogers Helicopters Inc · Fresno, CABuilt 1973 · S/N 30592 N911VRRogers Helicopters Inc · Fresno, CABuilt 1980 · S/N 30998 N9122ZIntermountain Helicopter Inc · Sonora, CABuilt 1975 · S/N 30716 N91419Overseas Aircraft Support Inc · Lakeside, AZS/N 33189 N914BTBell Textron Inc · Fort Worth, TXS/N 39164 N915HBBell Textron Inc · Fort Worth, TXBuilt 2025 · S/N 39150 N916BHBell Textron Inc · Fort Worth, TXS/N 39162 N921PDCity Of New York Police Department · Brooklyn, NYBuilt 2022 · S/N 39107 N922PDCity Of New York Police Dept · Brooklyn, NYBuilt 2022 · S/N 39112 N922VSVertol Systems Co Inc · Destin, FLS/N 30922 N933CHCoastal Helicopters LLC · La Verne, CABuilt 1969 · S/N 30062 N959TLU S Department Of Justice · Fort Worth, TXBuilt 2008 · S/N 36493

Back to AD 2012-22-06