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.

N103ATWjm Aviation LLC · Bridgeville, PABuilt 1970 · S/N 32-40951 N103BUColorado Aircraft Corp · Watkins, COS/N 31-7405202 N103CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N T18209142 N103EAJwp Group LLC · Long Island, MEBuilt 1976 · S/N 32R7780054 N103ENKjs Development LLC · Temecula, CABuilt 1995 · S/N 4622186 N103GLNaylor Aviation LLC · Columbia, MOBuilt 1978 · S/N 31-7912023 N103HPMcfarland Natalie · Roseburg, ORBuilt 1965 · S/N 24-4153 N103MRDeepvine Partners LLC · Simonton, TXBuilt 2004 · S/N T20608455 N1041CHelzer Timothy · Tucson, AZBuilt 2003 · S/N 270321 N1048DDumbravo Dustin C · Yorktown, VABuilt 2001 · S/N 27-0315 N1049TRoberts Kevin C · Athens, GABuilt 2003 · S/N 27-0319 N1049XValleyside Farm LLC · Woodstock, CTBuilt 1975 · S/N 32-7540132 N104KGKing & Co LLC · Arroyo Grande, CABuilt 2001 · S/N T18208008 N104MQL C Whitford Co Inc · Wellsville, NYBuilt 1979 · S/N 31-7952210 N104PSDepartment Of The Interior · Boise, IDBuilt 2019 · S/N T20609566 N1050BNine1on Industries LLC · Helena, MTBuilt 2001 · S/N 27-0312 N1050QCouch Kelly P · Elk Grove, CABuilt 2000 · S/N 27-0310 N1053WPcxii LLC · Greensburg, INBuilt 2007 · S/N T18208792 N1057QLofty Goals Aviation LLC · Liberty Lake, WABuilt 2007 · S/N T18208794 N1057ZAcc Transport LLC · Pomona, CABuilt 2007 · S/N T18208795 N105CBFlying Squirrel Aviation LLC · Blacksburg, VABuilt 1972 · S/N 31041 N105CHMach Tuck LLC · Daytona Beach, FLBuilt 1974 · S/N 27-7405419 N105DGFraser And Daughter LLC · Saint Augustine, FLBuilt 2024 · S/N 4636857 N105HPRyan Transportation Services Ltd · Marysville, OHBuilt 2003 · S/N 3257322 N105NRState Of Minnesota · Grand Rapids, MNBuilt 2024 · S/N T20609780 N105TLSlay Brothers Enterprises LLC · Winter Haven, FLBuilt 2003 · S/N T18208213 N1063CJim Johnson Nissan Inc · Bowling Green, KYBuilt 2006 · S/N 3257440 N1063QRussell Construction Co · Douglas, WYBuilt 1977 · S/N 32R-7780221 N1064SSterling Smkr3 LLC · Oklahoma City, OKBuilt 2007 · S/N 4636411 N1065DN1065d Mirage LLC · Rockville, MDBuilt 2006 · S/N 4636401 N1065SGiacobbe Francesco · Severna Park, MDBuilt 1994 · S/N 27-0187 N1065WCartwright Alexander Brooks · New Paris, INBuilt 1994 · S/N 27-0188 N1066BWexhler David R Trustee · Carlsbad, CABuilt 2006 · S/N 3257443 N1066SOmll Investments LLC · Ponte Vedra Beach, FLBuilt 2007 · S/N 3257457 N1068CGunlock Michael G · Boulder, COBuilt 2008 · S/N T18208822 N1069XEntelechy One LLC · Wichita, KSBuilt 1975 · S/N 32-7540134 N106ATLichtman Aaron Marcus · Baltimore, MDS/N 32R-7780326 N106BSFox Whiskey Inc · Wilmington, DEBuilt 2007 · S/N T18208746 N106CBRegional Appraisal Services Inc · Stone Mountain, GABuilt 1972 · S/N 73-31046 N106LValiair Lc Trustee · Casper, WYBuilt 2000 · S/N 3257130 N106REColorado Aircraft Corp · Watkins, COS/N 31-7752056 N1073GProfessional Flyers Corporation · Wilmington, DEBuilt 1994 · S/N 27-0191 N1075NBlackstone Barry V · Superior, NEBuilt 2007 · S/N 4636421 N10767Kansa Development Corporation Inc · Junction City, KSBuilt 2007 · S/N 4636409 N10782Kearbey Brandon · Hillsboro, ORBuilt 2007 · S/N T20608773 N10797Federal Flight LLC · Fairfax, VABuilt 2005 · S/N T20608525 N107APRegistration Pending · New Braunfels, TXRegistration pendingBuilt 2000 · S/N T20608202 N107MCVeratix Ventures LLC · Carlsbad, CABuilt 2013 · S/N 4636609 N107TANelson Sarah J · Anchorage, AKBuilt 1975 · S/N 32-7540099 N107TLGeier Jeffrey E · Colfax, WABuilt 2003 · S/N T18208216

Back to AD 71-13-01 R1