Registered aircraft · 6,916

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:71-13-01-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:71-13-01-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:71-13-01-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:71-13-01-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:71-13-01-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:71-13-01-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.

N66TBTurner Brothers LLC · Middleboro, MABuilt 1983 · S/N 31-8452014 N66TSTall Timber Flying Service LLC · Kalispell, MTBuilt 2001 · S/N T20608334 N66WMTriple R & B Aviation LLC · Miami Beach, FLBuilt 1966 · S/N 32-40002 N66YCWatts Loren · Hermiston, ORBuilt 2005 · S/N 27-0344 N6707FSeals Jeremy C · Goshen, KYBuilt 1976 · S/N 32R-7780035 N6708VAircraft Restoration Service Enhancements LLC · Mesa, AZBuilt 1970 · S/N 31011 N670MPStar Ground Services Inc · Tinian, MPBuilt 1971 · S/N 32-7140021 N6711YAero Services Lc · Woods Cross, UTBuilt 1968 · S/N 27-4039 N6716YGot Wings LLC · Woodbury, NYBuilt 1968 · S/N 27-4046 N6719LAwmr LLC · Conroe, TXBuilt 1969 · S/N 31-615 N6730YUrubek Raymond L · Refugio, TXS/N 27-4062 N6739YTropical Interisland Express Corp · Doral, FLBuilt 1968 · S/N 27-4073 N673CAM2 Aviation LLC · Summitville, INBuilt 2013 · S/N 4636589 N674TCUS Department Of Homeland Security · Washington, DCBuilt 2003 · S/N T20608380 N6751YLarson Kris K · Fullerton, CAFirst renewal noticeBuilt 1968 · S/N 27-4079 N6754YNovember Nine One Four Eight Juliet LLC · Fulton, MOBuilt 1968 · S/N 27-4083 N675DBFred Paul · Tampa, FLBuilt 2006 · S/N T20608643 N675KAAllis Kevin J · Columbia, MDS/N 14152 N6762LSummit Aviation LLC · Sun Valley, IDBuilt 1970 · S/N 31-664 N6768YPiper Aircraft Inc · Vero Beach, FLBuilt 1968 · S/N 27-4100 N676ARBlackdog Air LLC · Belton, SCS/N 31-8152182 N676SAVincennes University · Indianapolis, INBuilt 1979 · S/N 31-7912122 N677RARa Aviation LLC · Omaha, NEBuilt 1968 · S/N 24-4764 N6786YMuhlenkort Mary Anna · Beresford, SDBuilt 1968 · S/N 27-4122 N678BPMattson William Gordon · Pequot Lakes, MNBuilt 2007 · S/N T20608779 N678RKJ2k Plane LLC · Liberty Twp, OHBuilt 2004 · S/N T18208273 N678TBHunter Dennis F · Rohnert Park, CAS/N 1925 N678THSky High Aviation LLC · Shelby Township, MIBuilt 1978 · S/N 32R-7887283 N679BEBlue Eagle Aviation LLC · Birmingham, ALBuilt 2020 · S/N T20609621 N679CSRsix LLC · Turlock, CABuilt 2022 · S/N T20609679 N67CTRudd Wayne · Glenwood Springs, COBuilt 1989 · S/N 4622062 N67MLBgdr LLC · Wilmington, DEBuilt 1975 · S/N 340-0519 N67NGNwa Financial And Aviation Services LLC · Springdale, ARBuilt 2018 · S/N 4636727 N67SPBird Aviation · Salt Lake City, UTBuilt 1980 · S/N 32R-8029066 N67TFHorton Richard D · Woodland Park, COBuilt 1999 · S/N 27-0275 N67TGMccall Andrew Keith · Abilene, TXBuilt 1989 · S/N 4622032 N67WYTramel Air LLC · Midland, TXBuilt 1999 · S/N T20608122 N6810YAtem LLC · Helena, ALBuilt 1969 · S/N 27-4148 N6812JGottschalk William R · Fort Atkinson, WIBuilt 1976 · S/N 32R-7680352 N6817YInternational Air Services Inc Trustee · Carson City, NVS/N 27-4156 N681ATCaudullo Alfred A · Bolton, CTBuilt 1977 · S/N 32-7740038 N681DLHampton Michael D · Marshfield, MOBuilt 1965 · S/N 32-178 N6821MGig Aviation LLC · Harrisburg, ARBuilt 2025 · S/N T20609795 N6823YWingsleasing LLC · Wichita, KSBuilt 1969 · S/N 27-4163 N6825YDenton J Frederick · Hutchinson Island, FLS/N 27-4165 N682AKAk Aircraft LLC · Peoria, AZBuilt 2023 · S/N 4636824 N6836YOld School Aircraft LLC · Jackson, TNBuilt 1969 · S/N 27-4176 N683RLMach 10 Cap LLC · Fincastle, VABuilt 1978 · S/N 61P-0499-205 N6840JBeineke Paul · Marion, OHBuilt 1976 · S/N 32R-7680361 N6843YBarlam Theodore P · Poway, CABuilt 1969 · S/N 27-4187

Back to AD 71-13-01 R1