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.

N700WHRegistered aircraftBuilt 2022 · S/N 54997 N701ESSky Cycle LLC · Los Altos Hills, CABuilt 2005 · S/N 53635 N701HAHelo N701ha LLC · Richmond, VABuilt 2001 · S/N 4554 N702FSFlo-Sun Aircraft Inc · West Palm Beach, FLBuilt 2025 · S/N 56470 N705MTBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 54141 N70606Registration Pending · Rome, NYRegistration pendingBuilt 1989 · S/N 51282 N706CCCertified Aviation LLC · Wilmington, DEBuilt 1976 · S/N 2119 N706MTBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 54465 N707AHAspen Helicopters Inc · Oxnard, CABuilt 2005 · S/N 53632 N707MKSch Aviation Inc Trustee · NorfolkBuilt 2007 · S/N 4633 N707NARed Dragon Aviation LLC · Melbourne, FLBuilt 2001 · S/N 53468 N707SJCtrg Aviation Holdings LLC · Lakeway, TXBuilt 1981 · S/N 3561 N709MTMed-Trans Corp · Denton, TXBuilt 2015 · S/N 54585 N709WGSan Diego Co Sheriff Dept · El Cajon, CABuilt 2020 · S/N 54885 N70SPGreat Plains Aircraft Holding LLC · Papillion, NEBuilt 1968 · S/N 238 N710HPHendrickson Flying Service Inc · Rochelle, ILS/N 1755 N711TTFaithful Flyers LLC · Lakeside, CABuilt 1991 · S/N 51433 N711ZWMalmrose Heli Services Inc · North Salt Lake, UTBuilt 1979 · S/N 2691 N712FSTrans Texas Helicopter Services LLC · Realitos, TXBuilt 2014 · S/N 54497 N712GAFlagstaff Medical Center Inc · Flagstaff, AZBuilt 2011 · S/N 54084 N712HPDepartment Of Highway Safety And Motor Vehicles · Tampa, FLBuilt 2012 · S/N 54361 N712MScotts Helicopter Service Inc · Le Sueur, MNBuilt 1983 · S/N 51072 N712WRTrans Texas Helicopter Services LLC · Realitos, TXFirst renewal noticeS/N 2044 N713BCTimcoaviation LLC · Purvis, MSBuilt 1982 · S/N 3671 N713WRTrans Texas Helicopter Transport LLC · Realitos, TXS/N 52464 N714SHRockland County New York · New City, NYBuilt 2025 · S/N 56480 N7159HPremier Rotors LLC · Saint Martinville, LABuilt 1990 · S/N 51397 N715AEGm Leasing Company LLC · Broussard, LABuilt 2006 · S/N 53731 N715GWGoing To Work Aviation Also LLC · Wildwood, FLBuilt 2013 · S/N 54454 N7160VClassic Medical Inc · North Salt Lake, UTBuilt 1996 · S/N 53013 N7161JGlobal Overhaul Inc · Lafayette, LAS/N 135 N716DPCity Of Dallas · Dallas, TXBuilt 2012 · S/N 54369 N716VLAirwayplanner.Com LLC · Sands Point, NYBuilt 1992 · S/N 4203 N718DSVolusia Sheriffs Office · Deland, FLBuilt 2025 · S/N 56450 N718GHRotorcraft Support Inc · Fillmore, CABuilt 1999 · S/N 53361 N71HMSummit Helicopters Inc · Salem, VABuilt 1994 · S/N 52114 N71JJInterstate Helicopters Inc · Bethany, OKBuilt 1989 · S/N 51329 N71VAVirginia State Police · North Chesterfield, VABuilt 2020 · S/N 54898 N71WPSimjet Center Inc · Granbury, TXS/N 2702 N720BGentem Inc Trustee · Wilmington, DEBuilt 1980 · S/N 45452 N720CLQwest Corp · Broomfield, COBuilt 2012 · S/N 54371 N720DPCity And County Of Denver Colorado · Denver, COBuilt 2018 · S/N 54820 N720HPTennessee Highway Patrol Department Of Safety · Nashville, TNBuilt 2012 · S/N 54382 N722LMNorthwest Helicopters LLC · Olympia, WABuilt 1994 · S/N 52111 N723MTMed-Trans Corp · Denton, TXBuilt 2016 · S/N 54664 N723SFGm Leasing Co LLC · Broussard, LABuilt 1998 · S/N 53264 N724ACTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2024 · S/N 56411 N724BTBell Textron Inc · Fort Worth, TXS/N 54724 N7250EAg Air Inc · Oakdale, CABuilt 1974 · S/N 1529 N726AEAir Evac Ems Inc · Ofallon, MOBuilt 2008 · S/N 53871

Back to AD 2013-22-21