Skip to content

Registered aircraft · 5,086

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:91-21-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:91-21-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:91-21-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:91-21-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:91-21-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:91-21-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.

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 N726GJBeran James · Mahwah, NJBuilt 1980 · S/N 328024047 N726TBRead Russell P · Missoula, MTBuilt 2002 · S/N 2151 N7270VAirmotive Service LLC · Brigham City, UTBuilt 1967 · S/N 1320 N7273ZRegistration Pending · Canyon Lake, TXRegistration pendingBuilt 1999 · S/N T20608084 N7274C182 Flight Corp · Bronx, NYBuilt 1999 · S/N T20608059 N72758Hinton Larry L · Kirkland, WABuilt 2001 · S/N T18208004 N72768Tjs Rentals LLC · Glasgow, MTBuilt 2000 · S/N T20608146 N7277NTodom Air LLC · Anchorage, AKS/N T20608070 N7278CAndrews Jeb C · Monroe, LABuilt 1975 · S/N 32R-7680044 N72795Sides Enterprises LLC · Anthony, NMBuilt 1999 · S/N T20608092 N727CGOwens Keith E · Wrightstown, NJBuilt 2000 · S/N 18280838 N727CJMgr Aviation LLC · Chelsea, MIBuilt 1976 · S/N 14181 N727HBRiverside Farms · Sardis, MSBuilt 1980 · S/N 31-8112006 N727KWilliam L Schmidt Attorney At Law Pc · Fresno, CABuilt 1994 · S/N 4622178 N727MAMarc Inc · Bolton, MSBuilt 1976 · S/N 31-7652048 N727RLHammerton Kenneth R · Olive Branch, MSBuilt 1976 · S/N 31-7612056 N727SDStable Air LLC · Leonardtown, MDBuilt 1976 · S/N 32R-7780060 N727TVTuskegee Eagles Of St Jeseph Mo · Agency, MOS/N 74-31081 N72805Ace Aviators LLC · New Baltimore, MIBuilt 2000 · S/N T20608254 N7280ZGalt Ranch Aviation LLC · Wht Sphr Spgs, MTBuilt 1999 · S/N T20608079 N72819Mccune Ken · Lake Havasu City, AZBuilt 2000 · S/N T20608252 N728AABrinckerhoff Allen D · Windermere, FLBuilt 2004 · S/N T18208249 N728CAPremiere Aviation Inc · Wilmington, DEBuilt 1976 · S/N 31-7752035 N728SJHighland Aviation LLC · Flagstaff, AZBuilt 1981 · S/N 32R8129011 N7294PMcnamara Pa · Far Hills, NJBuilt 1978 · S/N 27-7854072 N72DNPostiglione Daniel · West Babylon, NYBuilt 1971 · S/N 24-5006 N72FAJones Donald T Jr · Barrigada, GUBuilt 1977 · S/N 31-7812023 N72FMBank Of Utah Trustee · Salt Lake City, UTS/N 27-0264 N72SB72 Sierra Bravo LLC · Allegany, NYBuilt 1971 · S/N 24-4969 N72SDYooper Aviation LLC · Menominee, MIBuilt 1972 · S/N 32-7240099 N72ZGSale Reported · Hood River, ORSale reportedBuilt 2006 · S/N T20608700 N730MCCpc2 Aviation LLC · Hoover, ALBuilt 1965 · S/N 27-3097 N731WN64gs LLC · Van Nuys, CABuilt 1971 · S/N 24-4989 N7332VLorenz William D · Benson, MNBuilt 1969 · S/N 32-1 N7335TNever Repress Laughter LLC · Villa Rica, GABuilt 1977 · S/N R18200029 N733GPHorton Luther · Lakeland, FLBuilt 1962 · S/N 24-3213 N735QStuart Aviation Holdings LLC · Stuart, FLBuilt 1978 · S/N 31-7812089 N735RCSoto Flavio Cesar · Nogales, AZBuilt 1998 · S/N 4636167 N736XPsa LLC · Fort Myers, FLBuilt 1973 · S/N 32-7340095 N737EBVx Ventures LLC · Castle Rock, COBuilt 2002 · S/N T18208135 N738CFishgold Valerie Trustee · Scottsdale, AZBuilt 2005 · S/N 3255028

Back to AD 91-21-01 R1