Skip to content

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.

N268RPTag Ag 04 LLC · Richmond, TXBuilt 2011 · S/N 4636511 N269MPGustafson H Clayton · Woodbury, CTBuilt 1980 · S/N 32R8029007 N269SHDan Julian LLC · Woodway, TXBuilt 2007 · S/N T18208729 N269ZIziair LLC · Mclean, VABuilt 2006 · S/N 3257407 N26GPGpi Geospatial Inc · Orlando, FLBuilt 1977 · S/N 31-7812001 N26HRiester Bernard J Jr DBA · Auburn, NYBuilt 1998 · S/N 3170 N26JRLerner Lance L · Bozeman, MTBuilt 2000 · S/N 27-0309 N26KMPerformance Aviation Solutions LLC · Meridian, IDBuilt 2001 · S/N T18208051 N26LS J D H LLC · Sewickley, PABuilt 1969 · S/N 32-40877 N26NZBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N T20608401 N26PGSan Angeles Aviation LLC · Phoenix, AZFirst renewal noticeBuilt 1990 · S/N 4622117 N26VRReed Edward · Marcellus, MIBuilt 2005 · S/N T20608563 N270FBQualitair LLC Trustee · MichelstadtS/N 27-0030 N270MEMm Aviation LLC · Casa Grande, AZBuilt 2000 · S/N T20608213 N270MLWard John L · Mexia, TXBuilt 2002 · S/N 3257297 N270SETrevor Corp · Green Lake, WIBuilt 2002 · S/N 233 N270SPSan Pedro Aviation LLC · San Antonio, TXBuilt 2025 · S/N T20609815 N271JLSouthwest Aviation Enterprises · Haslet, TXBuilt 2024 · S/N T20609778 N271LDVan Well Trucking LLC · Dallas, ORBuilt 2010 · S/N T20608977 N271MCSunshine Aero Industries Inc · Crestview, FLBuilt 1967 · S/N 31-175 N271MJGbs Aviation Inc Trustee · Wilmington, DEBuilt 1992 · S/N 27-0127 N27212Koke Edward Trustee · Goleta, CABuilt 2005 · S/N 27-0351 N27272Alpha United Air LLC · Wilmington, DEBuilt 1977 · S/N 31-7712063 N27275Island Wings Inc · Fort Lauderdale, FLBuilt 1977 · S/N 31-7712066 N27299C M B Aviation LLC · Farmington Hills, MIBuilt 1977 · S/N 31-7752128 N27349Valley Airways Inc · Scottsbluff, NEBuilt 1977 · S/N 31-7712087 N273FWeimer Heidi L · Knoxville, TNBuilt 1973 · S/N 32-7340138 N273MJSmith Jeffrey W · Shreveport, LABuilt 1979 · S/N 32R-7985065 N273TCStanford Doug · Oak Harbor, WABuilt 2013 · S/N T18209090 N27405N27405 Holding LLC · Palm City, FLBuilt 1977 · S/N 31-7752164 N2740K2740k LLC · Prospect, KYBuilt 2006 · S/N T18208514 N27418Sun Aircraft Management LLC · Ormond Beach, FLS/N 31-7752169 N27447Laingkids LLC · Lewes, DEBuilt 1977 · S/N 31-7812022 N27449Airchoice LLC · Manchester, IABuilt 1977 · S/N 31-7812025 N27450Flying Oyster Investments II LLC · Apollo Beach, FLBuilt 1977 · S/N 31-7812027 N27471Grant Aviation Inc · Anchorage, AKBuilt 1977 · S/N 31-7852018 N27478Hughes Ronnie D · Cedar Park, TXBuilt 1977 · S/N 31-7852026 N27481Sanborn Map Company Inc · Colorado Springs, COBuilt 1978 · S/N 31-7812009 N274CFair18 LLC · Montgomery, ALBuilt 2013 · S/N 4636578 N274CPCivil Air Patrol · Maxwell Afb, ALBuilt 2014 · S/N T20609127 N274DGBourne Michael Paul · Crystal Bay, NVBuilt 2004 · S/N T18208260 N27527N27527 LLC · Florence, SCBuilt 1977 · S/N 31-7852044 N27528Seacrest Seven LLC · Savannah, GABuilt 1977 · S/N 31-7852045 N27562Montcalm-Mcdonald LLC · Mansfield, LABuilt 1978 · S/N 31-7812050 N27567Plecenik William J · Erwinna, PABuilt 1978 · S/N 31-7812054 N275CTInfinity Real Estate LLC · Guaynabo, PRBuilt 1979 · S/N 318052019 N27647Aviation Department Inc · Avon Park, FLBuilt 1978 · S/N 31-7812084 N2765VWiebe Frank · Wellington, TXBuilt 1978 · S/N 31-7812048 N27663Warbelows Air Ventures Inc · Fairbanks, AKBuilt 1978 · S/N 31-7852094 N27666Lee Stephan J · Sacramento, CABuilt 1978 · S/N 31-7852097

Back to AD 71-13-01 R1