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.

N9855MNylund Michael K · Wasilla, AKBuilt 1967 · S/N 1034C N9861MSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1967 · S/N 1058C N9864MCizek Joseph E · Wasilla, AKS/N 1043C N9868MBeckwith Michael E · Kenai, AKS/N 1048C N9872MBatchelder James · Kenai, AKBuilt 1967 · S/N 1054C N9874KReintjes Byron · Fresno, CABuilt 1977 · S/N 28R-7803072 N987DCLewis Michael · Anaheim, CABuilt 1980 · S/N 28R8031103 N988CMAvc150 LLC · Carson City, NVBuilt 1973 · S/N P3370008 N988PWChristiansen Bruce L · Windham, MEBuilt 1978 · S/N R1722948 N9895KG R Q Partners Inc · Winston Salem, NCBuilt 1978 · S/N 34-7870046 N98968N83993 LLC · Cherry Hill, NJS/N 25-0542 N9908VDls Computer Services Inc · Lake In The Hills, ILBuilt 1977 · S/N R1722353 N9927VBunin David K · Rockwall, TXBuilt 1977 · S/N R1722354 N99376Skyrioca LLC · Wilmington, DEBuilt 1981 · S/N 25-0545 N9937CWhite Arnold Scott · Midland, TXFirst renewal noticeBuilt 1981 · S/N 25-0544 N993ASBig Muddy LLC · Southern Pines, NCBuilt 1981 · S/N 348133036 N9948VSchultz Vaughn P · Marysville, CABuilt 1977 · S/N R1722356 N994BDImpatient & Paranoid LLC · Birmingham, ALBuilt 2004 · S/N 3449310 N9956VFetch N Wag LLC · Sarasota, FLS/N R1722357 N9971VWalters Aaron R · Estes Park, COBuilt 1977 · S/N R1722358 N9984JJones Gary R DBA · Kalama, WABuilt 1986 · S/N 25-1080 N99855Dieckman Eric T · Glendale, AZBuilt 1981 · S/N 25-0550 N99895Skymotion LLC · Portland, ORBuilt 1981 · S/N 25-0551 N998AGAndrews Robert J Jr · Dubois, PABuilt 1979 · S/N 250217 N998ECCooper Andrew P · Glastonbury, CTBuilt 1998 · S/N 25-2020 N998MSteamboat Springs Flying Club Inc · Steamboat Springs, COBuilt 1977 · S/N R1722333 N9992Robinson Michael David · Folkston, GABuilt 1985 · S/N 1 N9994KMid South Painting Inc · Hohenwald, TNS/N 25-0552 N9996Qualitair LLC · MichelstadtBuilt 1977 · S/N 347770163 N9997FUsda Forest Service Fepp · Columbia, SCBuilt 1967 · S/N R1720247 N9998VCox Danny A · Panama City Beach, FLS/N R1722361 N999EWAmazonas Air Center And Maintenance Inc · Hialeah, FLS/N 34-7570159 N999LWTroposcatter Inc · Wilmington, DEBuilt 1978 · S/N R1722985 N999VTAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2002 · S/N 1246 N99DCCook Adam Richard · Lincoln, CABuilt 1977 · S/N 28R-7803109 N99HARuka Consulting LLC · Pewaukee, WIBuilt 1977 · S/N R1722281 N99HEJackson Andrew · Odessa, FLS/N R1722996 N99HKOtto Trever G · Verona, WIBuilt 1975 · S/N 6096C N99LWWe Enterprises LLC · Cheyenne, WYBuilt 1983 · S/N 25-0769 N99NVSagorski Daniel S · BerlinBuilt 2025 · S/N ES-213 N9CSChristensen Jon D · Kiowa, COBuilt 1973 · S/N P3370122 N9CTSafe And Sound LLC · Kalispell, MTBuilt 1972 · S/N P3370011 N9CVSeymour Ryan B · Coral Springs, FLBuilt 1972 · S/N P3370057 N9CXUr Culinary Xperience Catering Services LLC · Miami, FLBuilt 1973 · S/N P3370080 N9FSEagle Ey5 LLC · Ashland, MOBuilt 1977 · S/N 28R7703378 N9KYArgos Retail LLC · Mcallen, TXBuilt 1973 · S/N P337-0052 N9SELibby Investments LLC · Kalispell, MTBuilt 1974 · S/N P3370192 N9SKCustom Air International LLC · Homestead, FLBuilt 1981 · S/N 25-0601 N9VWillow Equipment LLC · Sharon Springs, KSS/N 6047C N9XYAdjoodani Farhad F · Glen Burnie, MDBuilt 1968 · S/N 17701187

Back to AD 81-13-10 R1