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.

N8002PKoerner Aviation Inc · Kankakee, ILBuilt 1962 · S/N 24-3242 N8005KShahan Nathan C · Heath, TXBuilt 1981 · S/N 32-8224003 N8005PAcklam David C · Yelm, WABuilt 1962 · S/N 24-3245 N8006JCrimson Star LLC · Virginia Beach, VABuilt 1981 · S/N 27-8154009 N8006QBramley Eric M · Avondale Estates, GABuilt 1981 · S/N 32R-8213016 N800DKBartlett Paul H · Nebo, NCBuilt 1976 · S/N 31-7612110 N800ELColumbia Asset Trust Corp Trustee · Wichita, KSBuilt 2026 · S/N T20609845 N800GRSaracino Stephen M · Stoughton, MABuilt 2008 · S/N 4692025 N800HSVertical Horizon Aviation LLC · Sandown, NHBuilt 2001 · S/N 3257246 N800JSJ M S Enterprises Inc · Doylestown, PABuilt 2012 · S/N 4636534 N800LPC A Aviation Corp · Clifton, TXBuilt 1983 · S/N 31-8352009 N800MSMcghee John M · Breckenridge, COBuilt 1991 · S/N 270107 N800MWNorpel Express LLC · New Bedford, MABuilt 1981 · S/N 31-8252011 N800ZHSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2014 · S/N 4692209 N8016PSteelera Aviation LLC · Wolfforth, TXBuilt 1962 · S/N 24-3260 N801CHRisse Greg L · Lincoln, CABuilt 1974 · S/N 31-7405460 N801DPSunset Aviation Services LLC · Coeur D Alene, IDBuilt 1960 · S/N 500B-999-30 N801KPlumlee James H · Bluffton, SCBuilt 1961 · S/N 500B-1094-57 N801PCGrand Michael · Palacios, TXBuilt 1965 · S/N 24-4256 N8021ULundell Brad · Kiron, IABuilt 1981 · S/N 28-8211020 N8023PShisier William · Tempe, AZBuilt 1962 · S/N 24-3267 N8024YValiair Lc Trustee · Casper, WYBuilt 1981 · S/N 32R-8229018 N8025JTorres Rafael · San Juan, PRBuilt 1978 · S/N 60-0503-163 N8028PTrest Robert J · Pelzer, SCBuilt 1962 · S/N 24-3274 N802BZYellow Dog Air LLC · Spokane Valley, WABuilt 2007 · S/N T18208737 N802GAMns Asset Management LLC · Dover, DEBuilt 1981 · S/N 31-8152103 N802SDFly Blew LLC · Fayetteville, ARBuilt 2004 · S/N T18208239 N8033RGoodson Aviation LLC · Tallahassee, FLS/N 31-7952065 N8041HKing Ag Leasing Inc · Sudan, TXBuilt 1981 · S/N 32R-8229022 N8041MLewis Edward H · Moorestown, NJBuilt 1981 · S/N 32R-8229023 N8042GTemple In The Sky LLC · Marietta, GABuilt 1981 · S/N 32R-8229024 N8043PGray Motors Inc · Port Angeles, WABuilt 1962 · S/N 24-3289 N8047SRisso Christopher W · Huntington Beach, CABuilt 1981 · S/N 32R-8229025 N804AFBlue Pearl Ventures LLC · Eighty Four, PABuilt 2021 · S/N 4636791 N804CSalcedo Eduardo · San Diego, CABuilt 2013 · S/N 4636602 N8052PCornerstone Dec Ltd · Chico, CABuilt 1962 · S/N 24-3298 N805APAsphalt Professionals Inc · Thousand Oaks, CABuilt 2011 · S/N T20608968 N805BBSpotted Dog 2021 LLC · Los Angeles, CABuilt 2007 · S/N T20608722 N805NJFreedom Capital Air LLC · Winchester, TNBuilt 1980 · S/N 31-8052109 N8062TDitullio Peter C · Fallbrook, CABuilt 1981 · S/N 32R-8229027 N8063MFriar Aerospace Group LLC · Jacksonville, FLBuilt 1978 · S/N 31-7852023 N8065JHerlihy John Joseph · Arroyo Grande, CABuilt 1978 · S/N 61P-0548-234 N8067JCc Air LLC · Orchard, NES/N 60-0550-178 N8067PShreve Jerry L · Warrensburg, MOBuilt 1962 · S/N 24-3314 N8069SGates Joel L · Salida, COBuilt 1981 · S/N 32R-8229028 N806RARegistered aircraftBuilt 2006 · S/N T20608691 N80702Over The Numbers LLC · Churchville, PABuilt 1981 · S/N 32R-8229030 N807ABSunward Aviation Services LLC · Merritt Island, FLS/N 31-8152183 N807FPM&A Industrial Construction LLC · Atkinson, NEBuilt 1977 · S/N 32R-7780518 N807MJNovisun LLC · Warminster, PABuilt 2014 · S/N 4692211

Back to AD 71-13-01 R1