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.

N599CDFourwinds Aviation LLC · Shelburne, VTBuilt 2005 · S/N 1525 N59DSDjm Holdings LLC · Sugar Land, TXBuilt 1981 · S/N 34-8133065 N59JFJpf Holdings LLC · Wilmington, DEBuilt 1977 · S/N R1722325 N59LMHunter Brian D · Scranton, IABuilt 1977 · S/N 28R-7703402 N59XPCobb John M · Fayetteville, TNBuilt 1977 · S/N R1722015 N5CYKawasaki Clyde H · Carson City, NVS/N P337-0083 N5JTTj Air Holdings Inc Trustee · Wilmington, DEBuilt 1972 · S/N 33701468 N5JYYoung John B · Panacea, FLBuilt 2010 · S/N ZA003 N5KRHana Like II LLC · Kailua Kona, HIBuilt 1979 · S/N P3370335 N5KVAdara Aircraft LLC · Burleson, TXS/N P3370338 N5LQCollignon William A Jr · Muscle Shoals, ALBuilt 1969 · S/N 33701202 N5RZBbz Consulting LLC · Cody, WYBuilt 1974 · S/N 33701554 N5SUFlorida Skymaster LLC · Cape Coral, FLBuilt 1969 · S/N 337-1134 N5VDRiverview Enterprises Inc · Perrysburg, OHBuilt 1978 · S/N 34-7870262 N5ZXPush Pull LLC · Lewes, DEBuilt 1977 · S/N P3370273 N600XPPintail Aero LLC · Shreveport, LABuilt 1976 · S/N R1722083 N601JBNixon Penny R · Wasilla, AKFirst renewal noticeBuilt 1977 · S/N 34-7770184 N602PGRjc Aviation Inc · Wilmington, DEBuilt 2002 · S/N 1189 N602SPPutlitz Richard A · Mukwonago, WIBuilt 1978 · S/N P3370324 N602VASchmidt Toby · Salt Lake City, UTBuilt 1976 · S/N 6027C N603SFPlunkett Timothy T · Port Orange, FLBuilt 1979 · S/N P3370340 N603VFArctic Environmental Services LLC · Pittsburgh, PABuilt 2003 · S/N 3449284 N6049HTorlone A J · Carlsbad, CABuilt 1977 · S/N 28R-7803082 N6053SFlying By LLC · Breckenridge, MNFirst renewal noticeBuilt 2003 · S/N 1328 N6054HNatelson Richard M · Salmon, IDBuilt 1977 · S/N 34-7870049 N606LPLee Andy · Riverside, CABuilt 1976 · S/N R1722020 N606RMachado Manel · Grass Valley, CABuilt 1977 · S/N 6062C N6071HArrow71h LLC · Phoenix, AZBuilt 1977 · S/N 28R-7803085 N6075KWilliams Todd D · Perry, UTBuilt 1976 · S/N R1722025 N6089HGromer Gerald M · Sebastopol, CABuilt 1977 · S/N 28R-7803088 N608BRArmwings LLC · Plainville, CTBuilt 2005 · S/N 1512 N609KYMorrison Neil E · Port Townsend, WABuilt 1967 · S/N R172-0225 N609MAAcenes LLC · White Plains, NYBuilt 1999 · S/N 3449109 N60YAnthem Commercial Air Services Inc · Saint Augustine, FLBuilt 1976 · S/N 33701735 N610MMMaxq Composites LLC · Oxford, MEBuilt 1968 · S/N 337-0961 N611GGPence Edward R · Bakersfield, CABuilt 1979 · S/N R1723110 N611MGIsr Platforms LLC · Mclean, VABuilt 1967 · S/N 337M0081 N612CDPanoramic Aviation LLC · Fort Collins, COS/N 1591 N612RTimm Robert S · Minneapolis, MNBuilt 1977 · S/N R1722687 N613WCAmpaire Inc · Hawthorne, CABuilt 1966 · S/N 337-0372 N6140HDiaz Jesse · Dothan, ALBuilt 1977 · S/N 28R-7803089 N6149KTurbine Financial Group LLC · Ogden, UTBuilt 1976 · S/N R1722029 N614XGMaher Jay A · Highlands Ranch, COBuilt 1977 · S/N 28R-7703262 N6150KAult Greg · Princeton, INBuilt 1976 · S/N R1722030 N6161HCouture Michael E · Conway, NHS/N 28R-7803091 N6163HSodolak Craig A · Magnolia, TXBuilt 1977 · S/N 28R-7803092 N6166HMccolley Gregory · Glendale, AZBuilt 1977 · S/N 28R-7803093 N616BBHarp Air LLC · Lowell, MIBuilt 1978 · S/N 34-7870288 N616SMDoo Dah Inc · Wilmington, DEBuilt 1990 · S/N 24-1691-14 N617KPPeck Ricky C · Snyder, TXBuilt 2013 · S/N 91088

Back to AD 81-13-10 R1