Skip to content

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.

N871PDJohnson Aircraft Leasing LLC · Springfield, ILBuilt 2000 · S/N 18280871 N8720FWaters Lindsay R · Deland, FLBuilt 1976 · S/N 32R-7780113 N8720PBarry Edward P III · Redlands, CABuilt 1965 · S/N 24-4169 N8721PLavergne Rusty P · Denham Springs, LABuilt 1965 · S/N 24-4170 N8722PMurphy Josiah I · Jarrettsville, MDS/N 24-4171 N8723PSima Ronald Scott · Glendale, AZBuilt 1965 · S/N 24-4172 N8725PAyoub Michael Kamal · Saint Charles, MOS/N 24-4174 N8729PBas Part Sales LLC · Greeley, COBuilt 1965 · S/N 24-4179 N872AFArmstrong Jay DBA · Muscotah, KSBuilt 2013 · S/N 4636598 N872JWWheeler Jeffrey A · Elyria, OHFirst renewal noticeBuilt 1972 · S/N 32-90 N872MN872m LLC · Batavia, OHBuilt 1998 · S/N 27-0248 N872RJ&J Surveying & Leasing LLC · Jacksonville, FLBuilt 1989 · S/N 4622028 N8732PComanche Aviation Inc · North Bend, OHBuilt 1965 · S/N 24-4182 N8733PSpaulding Rachael K · Saint Johns, FLBuilt 1965 · S/N 24-4183 N8735EKleiss James · Pesotum, ILBuilt 1976 · S/N 32R7680169 N8735PG B W Llp · Slidell, LABuilt 1965 · S/N 24-4185 N8741PCrimson Dawn Aviation LLC · Vinton, LABuilt 1965 · S/N 24-4192 N8742PLbb High Flyers LLC · Lubbock, TXBuilt 1965 · S/N 24-4194 N8743EKopitzke Christopher · Lexington, KYBuilt 1976 · S/N 32R-7680171 N8743PAckerman Garry A · Plano, TXBuilt 1965 · S/N 24-4195 N8744PJorheim Chris N · Altoona, PABuilt 1965 · S/N 24-4197 N8746PRatvasky Harry J · New Wilmington, PABuilt 1965 · S/N 24-4199 N8747PEdens Kenneth L · Hot Springs, ARS/N 24-4200 N874LLLandry Raymond M · Georgetown, TXBuilt 2005 · S/N T18208457 N8752EH & T Air LLC · Huron, SDBuilt 1976 · S/N 32R-7680173 N8754PHromek-Sawyer Diane · Lake Tomahawk, WIBuilt 1965 · S/N 24-4204 N8756PK T Graham Inc · Ephrata, PABuilt 1965 · S/N 24-4206 N8757PHix William W · Walsenburg, COBuilt 1965 · S/N 24-4207 N8758PMurphy Robert J · Deland, FLBuilt 1965 · S/N 24-4208 N8759EN8759e LLC · Wilmington, DES/N 32R-7680174 N8759PHeir Grant · Woodland, CAS/N 24-4209 N875DESoftcomm Aviation Inc · Irvine, CABuilt 2006 · S/N T18208659 N875FGFlightline Group Inc · Tallahassee, FLBuilt 2026 · S/N 4636875 N8760EArchie Airways LLC · Durant, OKBuilt 1976 · S/N 32R-7680175 N8761HLejeune Aerial Applications LLC · Basile, LAFirst renewal noticeBuilt 1976 · S/N 1516 N8762BRmp Capital LLC · Dubois, PABuilt 2015 · S/N 4636662 N8766PStephens Lloyd G · Saratoga, CABuilt 1965 · S/N 24-4216 N8767PGen-One Aviation LLC · Carlsbad, NMBuilt 1965 · S/N 24-4217 N8768KRegistered aircraftS/N 32-7340149 N8768PGliege Allan C · Middleton, IDBuilt 1965 · S/N 24-4218 N876EJEvans Ernest Levi Jr · Cary, NCBuilt 2011 · S/N T18209045 N8770PGores Thomas J · Franklin, WIS/N 24-4220 N8773PMcfly Cornhusker LLC · Sarasota, FLBuilt 1965 · S/N 24-4224 N8777PLil Dawg Aviation · Wilmington, DEFirst renewal noticeBuilt 1965 · S/N 24-4228 N8778PTrammell Shaun · Broken Arrow, OKBuilt 1965 · S/N 24-4229 N8779CForever Fly LLC · Margate, FLBuilt 1976 · S/N 32R-7680138 N877CVBrown Joseph Glenn · Desert Hills, AZBuilt 2004 · S/N T18208307 N877DSEvans Ashley E · Elizabeth, COBuilt 1967 · S/N 32-40185 N877DWAviation Concepts LLC · Coeur D Alene, IDBuilt 2001 · S/N T18208073 N877MVSorensen Bruce E · Murrells Inlet, SCBuilt 2008 · S/N 4692077

Back to AD 71-13-01 R1