Registered aircraft · 2,381

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

N403LFLife Flight Network LLC · Aurora, ORBuilt 2020 · S/N 54886 N403PHPhi Health LLC · Tempe, AZBuilt 1998 · S/N 53267 N403PJHelibro LLC · Red Bluff, CABuilt 1998 · S/N 53256 N403TDHfs Heli 1v LLC · New York, NYBuilt 2015 · S/N 54644 N4042GKlein Flying Service Inc · Lawrenceville, ILS/N 242 N404AEAir Evac Ems Inc · O Fallon, MOBuilt 2011 · S/N 52434 N404AMAir Methods LLC · Greenwood Village, COBuilt 2014 · S/N 54546 N404APA & P Helicopters Inc · Richvale, CABuilt 1997 · S/N 53228 N404LHLohman Helicopter LLC · Lewiston, IDBuilt 2007 · S/N 53777 N404LLRegistration Pending · Greenwood Village, CORegistration pendingBuilt 2000 · S/N 53446 N404MPIndustrial Helicopters LLC · Lafayette, LABuilt 1994 · S/N 52083 N404NCNorth Carolina State Highway Patrol · Cary, NCBuilt 2007 · S/N 53788 N404PHPhi Health LLC · Tempe, AZBuilt 1997 · S/N 53188 N404TDHfs Heli II LLC · New York, NYBuilt 2014 · S/N 54487 N405LFLife Flight Network LLC · Aurora, ORBuilt 2020 · S/N 54905 N405LHLohman Helicopter LLC · Lewiston, IDBuilt 1998 · S/N 53240 N405LPGm Leasing Co LLC · Broussard, LABuilt 1994 · S/N 52085 N405NCNorth Carolina State Highway Patrol · Cary, NCBuilt 2008 · S/N 53814 N405RLGlobal Aviation Florida LLC · Pompano Beach, FLBuilt 1990 · S/N 51405 N405SWSw Aviation LLC · Norman, OKBuilt 2013 · S/N 54391 N4067GDiamond Helicopters LLC · Los Angeles, CABuilt 1968 · S/N 226 N4068GGulf Coast Helicopters Inc · Pearland, TXBuilt 1968 · S/N 229 N406APA&P Helicopters Inc · Richvale, CABuilt 1999 · S/N 53357 N406ASAero Leasing Inc · Medford, ORFirst renewal noticeBuilt 2002 · S/N 53520 N406DBRight Brother Aviation LLC · Chaffee, NYBuilt 2002 · S/N 4561 N406KKKehler Kelly · Saint Xavier, MTBuilt 2004 · S/N 52283 N406LFLife Flight Network LLC · Aurora, ORBuilt 2021 · S/N 54977 N406MPGm Leasing Co LLC · Broussard, LABuilt 1994 · S/N 52086 N406NCNorth Carolina State Highway Patrol · Cary, NCBuilt 2023 · S/N 56335 N406PDCharlotte-Mecklenburg Police Dept · Charlotte, NCBuilt 2024 · S/N 56393 N406PHPhi Health LLC · Tempe, AZBuilt 1997 · S/N 53198 N406PJHelibro LLC · Red Bluff, CABuilt 2000 · S/N 53466 N406PWBank Of Utah Trustee · Salt Lake City, UTBuilt 1980 · S/N 45446 N406TDHfs Heli V LLC · New York, NYBuilt 2006 · S/N 53745 N406TRBrask T-4 Equipment LLC · Gallatin Gateway, MTBuilt 2025 · S/N 56473 N406TVTennessee Valley Authority · Muscle Shoals, ALBuilt 2020 · S/N 54900 N406WHHeli-Works Flight Services LLC · Deer Lodge, MTBuilt 1991 · S/N 51537 N407ABank Of Utah Trustee · Salt Lake City, UTBuilt 2024 · S/N 56389 N407ADOcean Air Helicopters Inc · Port Orford, ORBuilt 1988 · S/N 4023 N407AEAir Evac Ems Inc · O Fallon, MOBuilt 2009 · S/N 52409 N407AGBank Of Utah Trustee · Salt Lake City, UTBuilt 2020 · S/N 54893 N407AMAir Methods LLC · Greenwood Village, COBuilt 1998 · S/N 53309 N407APA & P Helicopters Inc · Richvale, CABuilt 1999 · S/N 53370 N407ARMed-Trans Corp · Denton, TXBuilt 2012 · S/N 54092 N407ATBizpay Aviation LLC · Tulsa, OKBuilt 2024 · S/N 56410 N407BBBravo Bravo LLC · Chandler, AZBuilt 2004 · S/N 53603 N407BDLitton Global LLC · Wilmington, DEBuilt 2020 · S/N 54891 N407BEL J Associates Inc · Latrobe, PABuilt 2003 · S/N 53576 N407BGAscendancy Aviation LLC · Melbourne Beach, FLBuilt 2007 · S/N 53796 N407BJ911 Aviation LLC · Durant, OKBuilt 2008 · S/N 53897

Back to AD 2013-22-21