Registered aircraft · 6,915

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.

N2137H3 Pandas LLC · Farmington, NMBuilt 2007 · S/N T20608721 N2138BSouthwest Aviation Enterprises · Haslet, TXBuilt 2003 · S/N T20608437 N2138FCima Christopher P · Plano, TXBuilt 1979 · S/N 32R-7987065 N2138KGrigsby Aaron A · Victorville, CABuilt 1978 · S/N 32R-7987070 N2139KPolly P LLC · Fort Worth, TXBuilt 1999 · S/N 27-0271 N213ACRtb Transport LLC · Evans, GABuilt 1984 · S/N 31-8452011 N213CLevins Kenneth · Alameda, CABuilt 2006 · S/N 3257436 N213PMLbair LLC · Hackensack, NJBuilt 2014 · S/N 4636622 N21406Makushin Logistics LLC · Fairbanks, AKS/N 31-7752117 N21425Nelson Phillip · Jonesboro, ARS/N 32R-7887207 N2142SDbm Farms Inc · Clarksdale, MSBuilt 2003 · S/N T18208224 N21435Car Guys Aviation LLC · Lead, SDBuilt 1978 · S/N 32R-7887210 N21436Smith Michael W · Bracey, VABuilt 1978 · S/N 32R-7887211 N2143BLance Aviation Corp · Houston, TXBuilt 1978 · S/N 32R-7987028 N21448Sputnik I LLC · Plymouth, MNBuilt 2000 · S/N 27-0298 N21459N21459 LLC · Farmington Hills, MIBuilt 1978 · S/N 32R-7887212 N2145RCabernet To Cactus LLC · Scottsdale, AZBuilt 2003 · S/N T20608427 N2145ZTextron Aviation Inc · Wichita, KSS/N T18208204 N21469Blubaugh Patrick S · Inyokern, CABuilt 1978 · S/N 32R-7887214 N2146CVan Bortel Aircraft Inc · Arlington, TXBuilt 2003 · S/N T18208222 N2148BKaroudjian David · Savannah, GAS/N 32R-7987030 N2148WSav LLC · Shelton, WABuilt 2003 · S/N T20608421 N21493Macmillan Robert J · Merritt Island, FLBuilt 2003 · S/N T20608423 N21494Dmc Air LLC · West Chester, OHS/N 32R-7887216 N21499Kling Clint W · Summerset, SDBuilt 1978 · S/N 32R-7887218 N214BPHolmes Aviation Inc · Webster, FLBuilt 2000 · S/N 3257156 N214HSDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 1975 · S/N 27-7654014 N214KRRogers Karl Dr · Nashville, TNBuilt 2008 · S/N 4692098 N214VWMilford Aviation LLC · Greensburg, INBuilt 2008 · S/N T20608837 N2150BGreen Head Flight Services LLC · Bemidji, MNBuilt 1979 · S/N 32R-7987031 N2150KCarey David John II · Mccall, IDBuilt 2003 · S/N T20608407 N2151YMtjc Services LLC · Chester, WVBuilt 2003 · S/N T18208207 N21538Keyser Soze LLC · Vancouver, WABuilt 1998 · S/N 27-0255 N2153NEagle Air US Inc · Eau Claire, WIBuilt 1979 · S/N 32R-7987096 N2153VGoro Sky Aircraft LLC · Lino Lakes, MNBuilt 1999 · S/N 27-0272 N21547Heaton Troy W · Pasco, WABuilt 2007 · S/N T18208695 N2154VMidwest Laser Service Inc · Janesville, WIBuilt 2007 · S/N T18208694 N2154XVital Sync LLC · Lakeway, TXS/N 27-0243 N2155JSlickhorns LLC · Reno, NVS/N T18208209 N2156EMaarouf Dan H · Taylor Village, TXBuilt 1978 · S/N 32R-7987062 N2156NTerryair LLC · Missoula, MTBuilt 2003 · S/N T20608409 N2157NC A R S Sales Inc · Denver, NCBuilt 1979 · S/N 32R-7987097 N2159PKiehn Real Estate LLC · Santa Barbara, CABuilt 2003 · S/N T20608432 N215VBBravo Air Ventures LLC · Salt Lake City, UTBuilt 2015 · S/N T20609210 N2161AHoyer Chase R · Jarrell, TXBuilt 1978 · S/N 32R-7985003 N2162WHelicopter Applicators LLC · Pembroke, NHBuilt 2004 · S/N T20608439 N2164YGolden Eagle Aviation LLC · Park Ridge, ILBuilt 2007 · S/N T18208685 N2165KAustin David · Cypress, TXBuilt 1999 · S/N 27-0259 N21683Flying H Inc · Hoxie, KSBuilt 1978 · S/N 32-7840188 N2168BBonjour Hugo E · Houston, TXBuilt 1978 · S/N 32R-7987032

Back to AD 71-13-01 R1