Registered aircraft · 619

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

N101HXHelicopter Express LLC · Chamblee, GABuilt 2024 · S/N 39123 N1022QAmerican Huey 369 Inc · Peru, INBuilt 1964 · S/N 64-14049 N1026YKuwait International Aircraft Leasing Inc · Wilmington, DEBuilt 2005 · S/N 36391 N102FWSierra Aeronautics LLC · Franklin, KYS/N 62-1905 N103HXHelicopter Express LLC · Chamblee, GABuilt 2024 · S/N 39125 N10432Huey 197 LLC · Argyle, TXBuilt 1968 · S/N 68-16197 N1044QReynolds Darryl G · Wills Point, TXS/N 66-17100 N104HFArmy Aviation Heritage Foundation · Hampton, GABuilt 1968 · S/N 68-16104 N105NJUsda Forest Service Fepp · Trenton, NJS/N 66-17071 (9265)N106CPSouthwest Florida Aviation Inc · Arcadia, FLS/N 1170 N106NJUsda Forest Service Fepp · Trenton, NJS/N 66-16030 (5724)N1073WBank Of Utah Trustee · Salt Lake City, UTBuilt 1976 · S/N 28012 N1079UTurbines Ltd · West Point, NEBuilt 1980 · S/N 31122 N107BZCounty Of San Diego · El Cajon, CABuilt 1968 · S/N 30013 N107CHAirlift Helicopters Services · Seal Beach, CABuilt 1967 · S/N 67-17290 N107NJUsda Forest Service · Trenton, NJS/N 13682 N1081CCelebrate Freedom Foundation Inc · West Columbia, SCBuilt 1973 · S/N 73-21685 N109MAMinuteman Aviation Inc · Missoula, MTBuilt 1968 · S/N 68-15334 N10RFBrown Helicopter Inc · Pensacola, FLBuilt 1973 · S/N 73-21715 N10WUBell Textron Inc · Fort Worth, TXS/N 7120010 N110LAConsolidated Fire Protection · Pacoima, CABuilt 2005 · S/N 36392 N110NWCbft LLC · Mobile, ALBuilt 1966 · S/N 66-16198 N111DRNorthwest Helicopters I Inc · Olympia, WABuilt 1996 · S/N 64-13699 N111UDDrive A Tank Inc · Kasota, MNS/N 70-16357 N113FDSacramento Metropolitan Fire District · Mather, CAS/N 70-16370 N1145QBrown Helicopter Inc · Pensacola, FLBuilt 1966 · S/N 66-16355 N114DRNorthwest Helicopters I Inc · Olympia, WABuilt 1995 · S/N 66-00792 N114FDSacramento Metropolitan Fire District · Mather, CAS/N 72-21558 N115FDSacramento Metropolitan Fire District · Mather, CAS/N 74-22330 N117DRNorthwest Helicopters I Inc · Olympia, WABuilt 1995 · S/N 65-12871 N118DRHeli-Huey Corp · El Paso, TXNon-citizen corporation, flight hours not reportedS/N 66-00903 N11NENorthern X Treme Helicopters Inc · Gridley, CABuilt 2001 · S/N 63-13086 N11PPUS Dept Of The Interior · Boise, IDBuilt 2003 · S/N 36316 N120FCUsda Forest Service Fepp · Tallahassee, FLS/N 70-16260 N120LACounty Of Los Angeles Fire Dept · Pacoima, CABuilt 2007 · S/N 36455 N120SHHelicopter Applicators Inc · Gettysburg, PABuilt 1972 · S/N 30119 N1215FJzw Aviation LLC · North Salt Lake, UTBuilt 1964 · S/N 64-13688 N121PTLrh Equipment LLC · Pendleton, ORBuilt 1964 · S/N 64-13711 N124FCUsda Forest Service Fepp · Tallahassee, FLS/N 64-13750 N124PTRegistration Pending · Bonners Ferry, IDRegistration pendingS/N 63-08817 N128FCAllied Response Inc · Copperas Cove, TXS/N 69-15848 N129SPNew York State Police · Albany, NYS/N 70-16205 N1304XNorthwest Helicopters LLC · Olympia, WAS/N 3169 N133Brown Helicopter Inc · Pensacola, FLBuilt 1966 · S/N 65-09847 N133LAConsolidated Fire Protection · Pacoima, CAS/N 39136 N1363WWithrotor Aviation Inc · Lakeview, ORBuilt 1966 · S/N 66-16854 N137USThomas Aviation LLC · Orleans, CABuilt 1965 · S/N 151874 N139TCBell Textron Inc · Fort Worth, TXS/N 39160 N141FAOrange County Fire Authority · Irvine, CABuilt 2008 · S/N 36484 N143PHWestern USA Solutions Inc · Kodiak, AKS/N 33134

Back to AD 2022-22-12