Registered aircraft · 2,382

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.

N620DEWestern Area Power Administration · Lakewood, COBuilt 2008 · S/N 53885 N620LHNorth Wind Aviation LLC · Cottage Grove, ORBuilt 1991 · S/N 51461 N622LTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2021 · S/N 54943 N622PAPatriot Aviation Inc · Greenville, DES/N 2729 N623QJb Air Services LLC · Brighton, COBuilt 1988 · S/N 51258 N624KRotary Flight LLC · Wilmington, DEBuilt 1974 · S/N 1540 N6259CCroman Corp · White City, ORS/N 703 N625PAWebster Bank National Association · New Britain, CTBuilt 2013 · S/N 54390 N626United States Department Of Interior · Boise, IDBuilt 1985 · S/N 51139 N62774Bell Textron Inc · Fort Worth, TXBuilt 1997 · S/N 53206 N629LSShook Farms LLC · Milan, MIBuilt 1984 · S/N 51077 N62EHJuliett Tango LLC · Alpine, WYBuilt 1991 · S/N 4191 N62FHelicopters Inc · Linden, NJBuilt 1995 · S/N 4341 N62FMMbm Aviation Consultants Inc · Wilmington, DEBuilt 1980 · S/N 2934 N62HPTanana Leasing Inc · Fairbanks, AKBuilt 2007 · S/N 52362 N62TVHelicopters Inc · Cahokia, ILBuilt 2008 · S/N 52369 N62ZA62za LLC · New York, NYBuilt 2014 · S/N 54155 N630GJDavis George E · San Dimas, CABuilt 2008 · S/N 52376 N630KHBell Textron Inc · Fort Worth, TXS/N 54659 N630RBBarrington Aviation LLC · Rocky Mount, NCBuilt 2012 · S/N 54328 N631MTMed-Trans Corp · Denton, TXBuilt 2015 · S/N 54631 N63446Helicopter Services Of Illinois LLC · Fisher, ILBuilt 1981 · S/N 3439 N6344DSummit Helicopters Inc · Salem, VABuilt 1993 · S/N 52008 N635GTSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 906 N63864Aircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1999 · S/N 4517 N63AEAir Evac Ems Inc · O Fallon, MOS/N 45499 N63DJSortie II LLC · Charlotte, NCBuilt 2024 · S/N 56399 N63PPLawrence Equipment Inc · South El Monte, CABuilt 2011 · S/N 54052 N63SHMaine Helicopters Inc · Whitefield, MEBuilt 1979 · S/N 2640 N6401XCity Of Memphis · Memphis, TNBuilt 1999 · S/N 4522 N640MAMinuteman Aviation Inc · Missoula, MTBuilt 2002 · S/N 53522 N641HAHelicopter Applicators Inc · Gettysburg, PABuilt 1991 · S/N 51444 N642AMAir Methods LLC · Greenwood Village, COBuilt 2025 · S/N 56465 N645AMAir Methods LLC · Greenwood Village, COBuilt 2025 · S/N 56467 N648CAChem-Air LLC · Shreveport, LABuilt 1982 · S/N 3626 N649ACLindsey Aviation Services · Haslett, TXBuilt 2020 · S/N 54879 N649AEAir Evac Ems Inc · O Fallon, MOBuilt 2008 · S/N 53872 N64AEAir Evac Ems Inc · O Fallon, MOBuilt 1997 · S/N 53138 N64AWN57aw LLC · Glendale, AZBuilt 2004 · S/N 52298 N64FCZma LLC · North Little Rock, ARBuilt 1981 · S/N 45539 N64GKAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1995 · S/N 4339 N64JBNc Transportation Inc · Loudon, NHBuilt 1978 · S/N 2437 N64TMLake State Companies LLC · Anchor Point, AKS/N 2513 N64WHWestwind Helicopters Inc · Santa Fe, TXBuilt 2005 · S/N 53659 N6501SInternational Air Services Inc Trustee · Carson City, NVBuilt 1990 · S/N 51395 N651HAHelicopter Applicators Inc · Gettysburg, PABuilt 1986 · S/N 51185 N65231Louisville Metro Government · Louisville, KYBuilt 2001 · S/N 5281 N652AEAir Evac Ems Inc · O Fallon, MOBuilt 2000 · S/N 53412 N652BBAgricultural Air Services LLC · Jupiter, FLBuilt 1984 · S/N 3800 N652HAHelicopter Applicators Inc · Gettysburg, PABuilt 1996 · S/N 52175

Back to AD 2013-22-21