Registered aircraft · 3,126

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

N329LAWells Flying Services LLC · Holdrege, NES/N 802A-0345 N329MMRuegg Aircraft Holdings LLC · Wilmington, NCBuilt 2001 · S/N 192 N32CARegistration Pending · Fairbury, NERegistration pendingBuilt 2005 · S/N 4697216 N330AVUas Transervices Inc · Boca Raton, FLBuilt 1986 · S/N U-230 N330DBBlueskyways LLC · Bend, ORBuilt 1999 · S/N LJ-1542 N331JPSfh Inc DBA · Fargo, NDBuilt 2005 · S/N LJ-1756 N331KECrop Air LLC · Eaton, COBuilt 1982 · S/N 400A-0460 N332ATAg Solutions LLC · Satanta, KSBuilt 1999 · S/N 802A-0087 N332BSHog Air Aviation Inc · Paragould, ARBuilt 2019 · S/N 802A-0791 N332MSLowcountry Aviation Company Brokerage LLC · Walterboro, SCBuilt 1982 · S/N LJ1023 N333BRB&R Aerial Crop Care Inc · Connell, WABuilt 2022 · S/N 802A-0989 N333MLSeneca Flight Group LLC · Clearwater, FLBuilt 2023 · S/N K039 N333QTQ Flight LLC · Bernardsville, NJBuilt 2000 · S/N BB-1702 N333XPRichard L Richards Pa Trustee · Coral Gables, FLBuilt 2000 · S/N LJ-1609 N333XXArnot Robert · Stowe, VTS/N 31T-7920038 N334BSMitchell Andrew D Trustee · Winnie, TXS/N 802A-0521 N3356YAdvanced Aviation Services LLC · Sheridan, WYBuilt 1992 · S/N FM-4 N335BSOld River Flying Service LLC · Helena, ARBuilt 2016 · S/N 802A-0643 N335QFBearcreek Flying Service LLC · Oakes, NDBuilt 2013 · S/N 802A-0522 N335WHDch Aircraft Leasing LLC · Hayden, IDS/N 335 N336KTBlue Sky Worldwide LLC · Wilmington, DEBuilt 2001 · S/N 4697033 N336RKBridger Aerospace Group Holdings LLC · Belgrade, MTBuilt 1992 · S/N FL-71 N337GTFl-337 LLC · Redondo Beach, CABuilt 2001 · S/N FL-337 N339BSB & S Air Inc · Lumpkin, GABuilt 2020 · S/N 802A-0839 N339KAChenango Aviation LLC · Dallas, TXBuilt 1980 · S/N LW-339 N33FGFlightline Group Inc · Tallahassee, FLBuilt 2026 · S/N 46020114 N33HGMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 2022 · S/N 4698200 N33KCCarvair LLC · Salem, ORBuilt 1984 · S/N FA-35 N33MCTwin Rivers Aircraft LLC · Sebastopol, CABuilt 2001 · S/N 1051 N3407GRedditt Air Service Inc · Cleveland, MSBuilt 1978 · S/N 43C N340LATri-Air Farms LLC · Mamou, LABuilt 2009 · S/N 802A-0349 N342THHill Thomas D · Parma, IDBuilt 1981 · S/N GM-87 N343KTRustair Inc · Anchorage, AKBuilt 1965 · S/N 1623TB-14 N343RRAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 2004 · S/N 4697197 N345CKCklass Transport Inc · Chula Vista, CABuilt 1990 · S/N FL-18 N346BALwcr Transportation Inc · Minot, NDBuilt 1999 · S/N BB-1653 N346TMDierking Jason Michael · Storm Lake, IABuilt 1996 · S/N 4636046 N347ERO'Briens Flying Service Inc · Iowa, LABuilt 2022 · S/N 802A-0944 N34ARoyal Air Freight Inc · Waterford, MIBuilt 1981 · S/N 110.350 N34GXPinpoint Logistics LLC · Cambridge, NEBuilt 2022 · S/N K034 N34HAHarper Aerospace LLC · Murfreesboro, TNS/N LM-120 N34HGUnited States Government · Fort Belvoir, VAS/N 34 N34LTPaper Boys LLC · Dover, DEBuilt 1992 · S/N BB-1437 N34RZUas Transervices Inc · Boca Raton, FLBuilt 1991 · S/N UC-151 N350ABGolden Eagle One LLC · Garden City, KSBuilt 1998 · S/N FL-212 N350BBRtd Air LLC · Hernando, MSBuilt 1990 · S/N FL-22 N350BDParrot Air LLC · Corpus Christi, TXBuilt 1994 · S/N FL-123 N350CFClemens Aviation LLC · Wichita, KSS/N FL-57 N350DRDeroyal Industries Inc · Powell, TNBuilt 1991 · S/N FL63 N350GACsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1990 · S/N FL-16

Back to AD 2016-05-13