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.

N914WCManzitto-Tripp Erin A · Denver, COBuilt 2007 · S/N 70399 N9152NH S Williams Co Inc · Marion, VABuilt 1997 · S/N 24-3408 N915DJF M V Associates LLC · Sarasota, FLBuilt 2002 · S/N 1168 N915SCI P M Ministries · Dufur, ORBuilt 1954 · S/N 26131 N915TXKing Daniel · San Antonio, TXBuilt 1981 · S/N 34-8133258 N91618Mnich William R · Powell, OHBuilt 1998 · S/N 25-2025 N9163NN2242z LLC · Newtown, CTS/N 3433139 N916CBOne One Delta Transit LLC · Wilmington, DEBuilt 1998 · S/N 25-2027 N9175ZMoeckel John H · North Venice, FLBuilt 1989 · S/N 2803003 N917GCCameron Gregory J · Chandler, AZBuilt 2012 · S/N 70360 N917RTSsn 215 Aviation LLC · New Lisbon, WIBuilt 2004 · S/N 1384 N919BGuastadisegni Joseph A Trustee · Oak Hills, CABuilt 1970 · S/N 33701307 N919JWJackson Benjamin · Zachary, LABuilt 1989 · S/N DM091 N919WAMatteo Properties Inc · Wickliffe, OHBuilt 1980 · S/N 34-8070147 N91AAShine Donald J · Waterford, WIBuilt 1971 · S/N 33701382 N91KTBrotherson Travis C · Holstein, IABuilt 1978 · S/N 34-7870387 N920DMCain Financial Inc · Fresno, CABuilt 1982 · S/N 28R-8231047 N920SCStannard Robert W III · Bloomington, INBuilt 2003 · S/N 1292 N9223RRegistered aircraftBuilt 1994 · S/N 3448040 N922PTPazik Randy · Pahrump, NVBuilt 1979 · S/N 25-0273 N923SBGig Harbor Airplane LLC · Gig Harbor, WABuilt 1975 · S/N P3370227 N9246QSullivan Daniel J · Medina, MNBuilt 1994 · S/N 3448045 N924ASA2g International LLC · San Juan Capo, CABuilt 1979 · S/N 33701908 N924DDSkyhigh317 Inc · Kingston Springs, TNBuilt 2004 · S/N 1443 N924JCCroman Graham P · Clayton, GAFirst renewal noticeBuilt 1977 · S/N 28R-7703196 N926JMBlue Horizon Performance Inc · Kellogg, IABuilt 1979 · S/N 28R-7931255 N926TMoore Thomas R · North Bay, NYBuilt 1975 · S/N 6095C N9274ZIsham Shane A · Wichita, KSS/N R172-0219 N927PPMartinez Lizette · Winter Park, FLBuilt 2003 · S/N 1367 N9284RKurath Dustin R · Menominee, MIBuilt 1997 · S/N 3449005 N928ASA2g International LLC · San Juan Capo, CABuilt 1979 · S/N 33701904 N928MBTraveling Pals III LLC · Fort Myers, FLBuilt 1985 · S/N 25-0859 N928SHPeros Dino · Pipersville, PABuilt 1975 · S/N 34-7670019 N928XAvant Homes LLC · Atlanta, GABuilt 1974 · S/N 347570066 N929TMMathson Timothy R Trustee · Mosinee, WIBuilt 2005 · S/N 1568 N92CRodriguez Michael C · Drums, PAS/N P3370128 N92GDStefenelli Aviation N-Tr Inc Trustee · AtterseeFirst renewal noticeBuilt 1979 · S/N P3370343 N92GMPeri Joseph · Thorntown, INBuilt 1978 · S/N 28R-7803263 N92JDDc Transit LLC · Juneau, WIBuilt 2004 · S/N 1468 N92JRInternational Air Services Inc Trustee · Carson City, NVS/N 1097 N92SCMorrison Neil E · Port Townsend, WABuilt 1967 · S/N R172-0211 N92UQuestair LLC · Bolton, MSBuilt 1991 · S/N 0001 N930ASA2g International LLC · San Juan Capo, CABuilt 1976 · S/N 33701854 N93216East Moriches Aerial Advertising Ltd · Ridge, NYBuilt 1966 · S/N R172-0110 N9323CHangar 9 Inc · Aberdeen, SDBuilt 1978 · S/N 28R7803252 N9333KOrlandi Properties LLC · Blairstown, NJBuilt 1976 · S/N 34-7670198 N9347NDavis Braeden L · Blanchard, OKBuilt 1969 · S/N 28R-35048 N9348NPletcher Gayle L · Topeka, KSBuilt 1969 · S/N 28R-35049 N9349NStutzman Gary A · Watsontown, PAS/N 28R-35050 N934SBLac Aero LLC · Liberal, KSBuilt 1978 · S/N 34-7970061

Back to AD 81-13-10 R1