Skip to content

Registered aircraft · 6,916

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:71-13-01-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:71-13-01-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:71-13-01-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:71-13-01-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:71-13-01-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:71-13-01-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.

N720KMTrubee Jay G Trustee · Palm Desert, CABuilt 2002 · S/N 3257300 N720WDThorntons Aircraft LLC · Tuscaloosa, ALBuilt 2003 · S/N 3257327 N721AREagle Wings Holdings LLC · Greenwood, INBuilt 2024 · S/N T18209147 N721CEErtel Thomas H · Charlotte, NCBuilt 1980 · S/N 31-8112002 N721FLSilver Creek Aviation Services · Fort Worth, TXFirst renewal noticeBuilt 2019 · S/N T20609591 N721RWGulf Coast Business Advisors LLC · Pineville, LABuilt 2021 · S/N 4636781 N721WWLmg - Rba LLC · Uhland, TXBuilt 2016 · S/N T20609222 N722AVMcdaniel Ibarra Professional Services Inc · Palm Desert, CABuilt 1976 · S/N 32R-7780029 N722CZThree D Adventures LLC · Newfolden, MNBuilt 1999 · S/N T20608118 N722ETSymonds Stephen M · Colleyville, TXBuilt 1996 · S/N 4636047 N722LWWineberg Lindsay · Beverly Hills, CABuilt 1976 · S/N 14062 N722PWRamsey Asphalt Construction Corp · Santa Maria, CABuilt 2023 · S/N T18209116 N722RMFisher Mark A · Leola, PABuilt 1974 · S/N 32-7440140 N722SEBlair Management Holdings LLC · Durango, COBuilt 2023 · S/N T20609730 N722TTNext Gen Aviation LLC · Jenks, OKBuilt 1976 · S/N 60-0285-108 N7234CConfidential LLC · Lutz, FLBuilt 1975 · S/N 32R-7680043 N723DGEyefly LLC · Hastings, NEBuilt 2023 · S/N 4636827 N723KYCommonwealth Of Kentucky · Frankfort, KYBuilt 1978 · S/N 31-7852122 N723TCWisodak Air LLC · Eau Claire, WIBuilt 2024 · S/N T18209156 N724ATH Squared Aviation LLC · Sheridan, WYBuilt 1984 · S/N 32R-8429027 N724CPCivil Air Patrol · Maxwell Afb, ALBuilt 2019 · S/N T20609570 N724KBAdg Logistics LLC · Riverside, CABuilt 2013 · S/N 4692196 N724WRichard A Klie · Edwardsville, ILS/N 27-0338 N7256DAir Supremacy LLC · Bend, ORBuilt 1999 · S/N T20608068 N72582Surdex Corp · Chesterfield, MOFirst renewal noticeBuilt 1999 · S/N T20608114 N7258ZGraber Jesse B · Northfield, MNBuilt 1999 · S/N T20608113 N7259VKnutson Wayne R · Thompson, NDFirst renewal noticeBuilt 1967 · S/N 1313 N725EDMolden Erik · Newtown, PABuilt 2012 · S/N 4636555 N725MA100ll First Class LLC · Santa Rosa Beach, FLBuilt 2023 · S/N 4636835 N725RSHandwerk William C · Georgetown, TXS/N 27-0026 N725TBAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2003 · S/N 2201 N72608Gv Air Inc · Medford, ORBuilt 2001 · S/N T20608268 N7260KAmbitious Aviation LLC · Newport News, VABuilt 2000 · S/N 18280895 N72623Law Office Of Vincent G Rieger Pc · Kalispell, MTS/N T20608162 N7262ACf Aviation Trust LLC Trustee · Wilmington, DEBuilt 2000 · S/N 20608138 N72634Rnd Technologies LLC · Lancaster, CABuilt 1999 · S/N T20608108 N72638Dysart Jack L · Steamboat Springs, COBuilt 1999 · S/N T20608127 N7264HDelta Sierra Aviation LLC · White Salmon, WABuilt 1999 · S/N T20608103 N7265Walker Teresa L · Enid, OKBuilt 1963 · S/N 24-3454 N7265REmerald City Aircraft Leasing Inc · Port Orchard, WAS/N T20608045 N7266BButtonwood Construction LLC · Islamorada, FLBuilt 2001 · S/N T18208003 N7268Y612 Holdings Lp · Decatur, TXS/N T20608046 N7268ZWestwind Aviation Inc · Phoenix, AZBuilt 1999 · S/N T20608048 N72695Surdex Corp · Chesterfield, MOBuilt 2001 · S/N T20608274 N72696Bass Adventures LLC · Anchorage, AKBuilt 2001 · S/N T20608270 N7269CCollins Carliss Alvin · Andrews, TXBuilt 1999 · S/N T20608055 N7269KDeatley Crushing Company Inc · Lewiston, IDBuilt 1999 · S/N T20608056 N7269TAg N7269t LLC · Salt Lake City, UTBuilt 1999 · S/N T20608050 N7269XCummings Cove Air LLC · Gloucester, MAS/N T20608054 N726BWBoberts LLC · Beach Lake, PABuilt 2010 · S/N 4636478

Back to AD 71-13-01 R1