Registered aircraft · 380

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:2000-15-21-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:2000-15-21-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:2000-15-21-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:2000-15-21-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:2000-15-21-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:2000-15-21-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.

N1022QAmerican Huey 369 Inc · Peru, INBuilt 1964 · S/N 64-14049 N102FWSierra Aeronautics LLC · Franklin, KYS/N 62-1905 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)N106NJUsda Forest Service Fepp · Trenton, NJS/N 66-16030 (5724)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 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 N120FCUsda Forest Service Fepp · Tallahassee, FLS/N 70-16260 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 N133Brown Helicopter Inc · Pensacola, FLBuilt 1966 · S/N 65-09847 N1363WWithrotor Aviation Inc · Lakeview, ORBuilt 1966 · S/N 66-16854 N137USThomas Aviation LLC · Orleans, CABuilt 1965 · S/N 151874 N143SPRegenald Michaud Aviation LLC · Willows, CAS/N 66-01065 N145MAMinuteman Aviation Inc · Missoula, MTBuilt 1972 · S/N 72-21584 N14SDLake County Sheriffs Office · Tavares, FLBuilt 1962 · S/N 62-12369 N154TLJtbam Inc · Lakeside, AZBuilt 1988 · S/N 154770 N155TLTwo Roan Ranch LLC · Salem, ORBuilt 1967 · S/N 154779 N16315Army Aviation Heritage Foundation And Flg Museum · Hampton, GABuilt 1971 · S/N 70-16315 N16493Astre Air International · Watkins, COS/N 66-16493 N166DROas2 LLC · Orlando, FLBuilt 1995 · S/N 66-16949 N16TVSei Holdings LLC · Missoula, MTBuilt 1969 · S/N 69-15455 N174SPNew York State Police · Albany, NYS/N 63-12997 N186SDOrange County Sheriffs Dept · Costa Mesa, CAS/N 74-22540 N191CEBrones Jon P · Blanco, TXS/N 66-17061 N192BPJones Flying Service · Biggs, CABuilt 1965 · S/N 65-10133 N194BPJones Aviation Inc · Biggs, CABuilt 1967 · S/N 67-17420 N19CFPowers Michael · Granbury, TXS/N 66-01145 N19SPNew York State Police · Albany, NYS/N 64-13666

Back to AD 2000-15-21 R1