Registered aircraft · 4,001

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:81-13-10-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:81-13-10-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:81-13-10-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:81-13-10-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:81-13-10-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:81-13-10-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.

N89SDState Of South Dakota · Pierre, SDBuilt 1979 · S/N 34-8070089 N8CVWbg 8cv LLC · Lincolnton, GABuilt 1972 · S/N P337-0056 N8CYN8cy LLC · Rosemary Beach, FLBuilt 1973 · S/N P3370082 N8SEAlexander Edward W · Loudonville, NYBuilt 1974 · S/N P3370191 N8YPClear Blue Marketing Inc · Reno, NVBuilt 1973 · S/N 2187C N9007JMalcolm Douglas B · Shell Beach, CABuilt 1967 · S/N 337-0729 N900RTTakle Raymond L · Hudson, WIBuilt 1979 · S/N R1723160 N9011CParios Vasilios · Northfield, MAS/N 28R-7803243 N9012KDerbyshire William · Davie, FLBuilt 1977 · S/N 28R-7803057 N901EGK Mcdaniel LLC · Mesa, AZBuilt 1977 · S/N 34-7770426 N901LJPegasus Flight Resources LLC · Charlotte, VTS/N 6715191 N901SPBailey Michael W · Watauga, SDBuilt 1976 · S/N 6180C N9020ECaturia Jeffrey · Layton, UTBuilt 1976 · S/N 6190C N9022KRyczek Walter Alan · Huntersville, NCBuilt 1977 · S/N 28R-7803059 N90252Weigman Michael S · Altamonte Springs, FLBuilt 1967 · S/N R1720191 N902ATreherne James · Clifton, VABuilt 1968 · S/N 68-6872 N902ESDodson International Parts Inc · Rantoul, KSFirst renewal noticeBuilt 2002 · S/N 1253 N90318Nelson Larry Trustee · Almena, KSBuilt 1946 · S/N 332 N9039ERegistered aircraftBuilt 1977 · S/N 6194C N903KKHanger Nine Point Five LLC · Aztec, NMBuilt 1970 · S/N 33701263 N9041YGrandy Boyd · Arcadia, CABuilt 1956 · S/N 214/252 N904BFGrandbear Air LLC · Mountain Green, UTS/N 3630 N9050KFender Jason · Jacksonville, ARBuilt 1977 · S/N 28R-7803060 N9051VWhite Air Ltd · Dover, DEBuilt 1977 · S/N 28R-7703334 N9053KBrown Aero Technologies LLC · Alexander City, ALBuilt 1977 · S/N 34-7870035 N905KKRdc Air LLC · Lithia, FLBuilt 1970 · S/N 33701348 N9062ERegistered aircraftBuilt 1977 · S/N 6192C N9065ERatliff Stan D · Wasilla, AKBuilt 1977 · S/N 6193C N906QKVilla Aircraft Maintenance Inc · Fort Lauderdale, FLBuilt 1977 · S/N 34-7770309 N9072ECarlos Gary N · Togiak, AKS/N 6195C N9075ETalley Clifford C · Chowchilla, CABuilt 1977 · S/N 6196C N908KSKingsky Flight Academy LLC · Lakeland, FLBuilt 1978 · S/N 34-7970060 N908NTBud E Aero Inc · Franklin Square, NYBuilt 1983 · S/N 25-0779 N909RAJw Aero Holdings Inc · Canandaigua, NYBuilt 1976 · S/N 34-7770069 N90HLIronrod Aviation LLC · Moorpark, CAS/N 6031C N910CDDubach Carter Douglas · Norco, CABuilt 2002 · S/N 1247 N910FVip Aviation LLC · Sunrise, FLBuilt 1983 · S/N 34-8333088 N910TN910t LLC · Newark, OHBuilt 1970 · S/N TC-1361 N910TWMultnomah County Sheriffs Office · Portland, ORBuilt 1979 · S/N R1723279 N9114KSt Barth Rallye Inc Trustee · Wilmington, DEBuilt 1976 · S/N 34-7670188 N911ZSBernalalillo County Sheriffs Office · Albuquerque, NMBuilt 1968 · S/N R172-0292 N9125EWhitesell Nowland G · Loudon, TNBuilt 1977 · S/N 6199C N91284Lee John · Marietta, OHBuilt 1979 · S/N 347970111 N912CPhelps Austin I · Palmer, AKBuilt 1998 · S/N 108-3912 N912LLLegacy Air LLC · Cadillac, MIBuilt 1978 · S/N 34-7870020 N9134QAviation Specialty Services LLC · Beaufort, NCBuilt 1968 · S/N 337-M0185 N9139KSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1976 · S/N 34-7670189 N9145EScott Alan B · Puyallup, WABuilt 1977 · S/N 6201C N9145MValenzuela Anthony R · Glendale, AZBuilt 1985 · S/N 28R-8531014 N914CBChan Blair H · Arlington, TXBuilt 1977 · S/N R1722705

Back to AD 81-13-10 R1