Registered aircraft · 4,000

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.

N1416XTop Tier Truck And Trailer LLC · Dimmitt, TXBuilt 1975 · S/N 34-7570241 N1417LBright David P · Wachapreague, VABuilt 1965 · S/N M-809 N1422TRead Travis · Lumberton, TXBuilt 1982 · S/N 34-8133277 N1423CGlovis Mark S · Wyandotte, MIBuilt 2003 · S/N 1318 N1425MRhino Capital Holdings LLC · Bonaire, GABuilt 1974 · S/N P3370162 N142GDDeaero LLC · Darwin, MNBuilt 1980 · S/N 34-8070314 N142MSPlane Fun Inc Tr Trustee · Snellville, GAS/N 28R-8331017 N142SFN142sf LLC · Scottsdale, AZS/N 1527 N142TVPaulson Douglas W · Miami, FLBuilt 1979 · S/N 28R8031020 N1437VBell John C · Wakefield, NHBuilt 1976 · S/N R1722190 N143JBKing John · Torrance, CABuilt 1965 · S/N 337-0102 N143PBHemdmm Corp · Wilmington, DEBuilt 1977 · S/N 28R-7703243 N143RJDelta Tango Aviation LLC · Saint Louis, MOBuilt 2003 · S/N 1276 N1444ASocha-Leialoha John B · Bellevue, WAS/N P3370308 N14455Pinkerton Matthew L · Milton, FLS/N R-172-0143 N14457Stone Kenneth R · Cedar Springs, MIBuilt 1966 · S/N R172-0120 N14460Ajkj Aviation LLC · Erie, COS/N R1720121 N1448VGeisler Eric L · Eugene, ORBuilt 1976 · S/N R1722193 N144JKLong Island Aviators LLC · Seaford, NYBuilt 1981 · S/N 34-8133010 N1451XTrb Aviation Inc · Washington, DCBuilt 1975 · S/N 34-7570248 N145AWSteere Anna · New Albany, OHBuilt 2004 · S/N 1402 N145PCAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1973 · S/N 0383 N1467VLumpkin Aviation LLC · Dahlonega, GABuilt 1976 · S/N R1722194 N1467XWilson David K · Mckinney, TXBuilt 1975 · S/N 34-7570252 N146ACUnited States Air Force Owner · Usaf Academy, COBuilt 1967 · S/N R1720147 N146JJValiair Ltd Co Trustee · Casper, WYBuilt 2002 · S/N 1265 N147BZSpace Coast Aircraft Co · Merritt Island, FLBuilt 1978 · S/N 34-7870359 N147CCBright Skies Inc · San Jose, CABuilt 1980 · S/N 28R-8131025 N148CDAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2000 · S/N 1044 N148PFMacallen Chemical Inc · Monroe, LABuilt 1978 · S/N 34-7970017 N14FZWurzer Frank · Tallmadge, OHBuilt 1978 · S/N 34-7870122 N14JNNational Test Pilot School · Mojave, CABuilt 1975 · S/N 34-7570254 N14KCAviation Engineering Technical Services Inc · Savannah, GABuilt 1979 · S/N 28R-7931082 N14MRMarlin Aviation Flying Service LLC · West Palm Beach, FLBuilt 1972 · S/N 33701459 N14PNNefas Paul J · Sunland, CABuilt 1977 · S/N R1722602 N1501VChinook Flying Club LLC · Chinook, MTBuilt 1976 · S/N R1722197 N150JBMyers Clifford A · Arbuckle, CABuilt 1977 · S/N R1722521 N15138Lone Star Flight Museum · Houston, TXBuilt 1967 · S/N R1720133 N1514VVanreeth James E · Washington Island, WIBuilt 1976 · S/N R1722198 N15178Gill Robert S · Woodinville, WABuilt 1966 · S/N R172-0179 N15194Mcgrath Kevin M · Cloquet, MNBuilt 1967 · S/N R172-0195 N151JFAero Quest LLC · Highland, UTBuilt 1977 · S/N 28R-7703405 N151PBarth Brian W · Port Orange, FLBuilt 1972 · S/N P3370058 N1521VBlack Hill Consulting LLC · Lake Havasu City, AZBuilt 1976 · S/N R1722199 N1530VThompson David Ray · Greenwood, SCBuilt 1976 · S/N R1722200 N1532XRaymond Darwin V · Glenwood Springs, COBuilt 1975 · S/N 34-7570275 N1536XClark Christopher · Ormond Beach, FLBuilt 1975 · S/N 34-7570276 N154PTTcb Elite LLC · Helena, MTBuilt 1979 · S/N 28R-8031006 N154SDWarnes Thomas S · Tampa, FLBuilt 2002 · S/N 1197 N1551XLeverson Christopher · Austin, TXBuilt 1975 · S/N 34-7570283

Back to AD 81-13-10 R1