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.

N93710Obrian Brandon · Travelers Rest, SCS/N 73-32-121 N9371YBob Gist Insurance Agency Inc · Jonesboro, ARBuilt 2012 · S/N T18209061 N9372PBeery Milo A · Clarinda, IABuilt 1969 · S/N 24-4872 N9373PLeff Benjamin Franklin · Cedar Park, TXBuilt 1969 · S/N 24-4873 N9379PAerodata Inc · Edgewater, MDBuilt 1969 · S/N 24-4880 N9380KResource And Management Group Ltd · Cheyenne, WYFirst renewal noticeBuilt 1976 · S/N 32R-7680211 N9380PEchelmeier Stanton M · Fort Payne, ALBuilt 1969 · S/N 24-4881 N9381BDoctor Bad Ass LLC · Kalispell, MTBuilt 2012 · S/N T20609039 N9381PSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 24-4882 N9382PRegistered aircraftBuilt 1969 · S/N 24-4883 N9383RSmith Casey B · Springer, OKS/N 905-14 N9384PDarling Rob K Dds · Venice, FLBuilt 1969 · S/N 24-4885 N9385CRobinson Steven Christopher · Enid, OKS/N 32R-7885046 N9386PWilson Jay · Omro, WIBuilt 1969 · S/N 24-4887 N938DDSkytech Investment Drilling Inc · Phoenix, AZBuilt 2006 · S/N T20608615 N938PMD & B Aviation LLC · Stroudsburg, PABuilt 1983 · S/N 31-8452013 N9390PFlaherty Stephen · El Paso, TXBuilt 1969 · S/N 24-4891 N9391PRusty Ventures LLC · Watertown, SDS/N 24-4893 N9392KDevils Lake Aero LLC · Devils Lake, NDBuilt 1976 · S/N 32R-7680219 N9393PBoucher Bobbi · Fredericksburg, VABuilt 1969 · S/N 24-4895 N9394PS A Freight International Inc · San Antonio, TXBuilt 1969 · S/N 24-4897 N9395PPlane Fun Inc Tr Trustee · Snellville, GABuilt 1969 · S/N 24-4898 N9396PTrom Michael S · Lake Ozark, MOBuilt 1969 · S/N 24-4899 N9397PStarritt Mark C · Hollister, CABuilt 1969 · S/N 24-4901 N9398PS & T Aviation LLC · Meriden, IABuilt 1969 · S/N 24-4902 N939CAMcs Aviation LLC · Larned, KSBuilt 1965 · S/N 24-4222 N939PASch Aviation Inc Trustee · NorfolkBuilt 2008 · S/N 4692093 N93CDDe Leon Jonas · New York, NYBuilt 1993 · S/N 27-0153 N93GKFirenze Investment Group Two LLC · Saint George, UTBuilt 2015 · S/N 4636667 N93PNHawkins Steven L · Grand Prairie, TXBuilt 1974 · S/N 32-7440091 N93RJStamm David · Lake Almanor, CAS/N 4622130 N93VBSky Blue Inc · Wilmington, DEBuilt 1978 · S/N 32R-7887176 N9400PKoretsky Aviation LLC · Fairless Hills, PABuilt 1969 · S/N 24-4904 N9402PSteinberg Franklyn C III · Flemington, NJBuilt 1969 · S/N 24-4907 N94079Burney Jeffrey W · Sorrento, FLBuilt 2012 · S/N T18209057 N9407PHoefle Aviation Inc · Wilmington, DEBuilt 1969 · S/N 24-4912 N9409PDormond Brent C · Glendale, CABuilt 1969 · S/N 24-4914 N940MRRooney Michael · Pittsburgh, PABuilt 2018 · S/N T20609530 N9411PHomsi Joseph · Dover, NJBuilt 1970 · S/N 24-4916 N9412PJ L Darr And Son Inc · High Point, NCBuilt 1969 · S/N 24-4917 N94141Romer-Pollis Victoria Elizabeth · Lake Havasu City, AZBuilt 2012 · S/N T20609051 N9419PGreene Joseph B · Shafer, MNBuilt 1969 · S/N 24-4925 N941JDiane And Cliff Knight Properties LLC · Houston, TXBuilt 2025 · S/N T20609806 N941SFSuncoast Flyers Inc · Venice, FLBuilt 2026 · S/N T20609836 N941TLandings At Quonset Airport LLC · Exeter, RIBuilt 2006 · S/N T18208486 N9427PPaul Burrell Aircraft LLC · Spring, TXBuilt 1969 · S/N 24-4935 N942BMegkat Equipment LLC · Lewes, DEBuilt 2012 · S/N 4636538 N942EAngry Manx LLC · Riverside, CABuilt 1975 · S/N 31-7552116 N942EHHeritage Aviation Management Ltd · Conroe, TXBuilt 2021 · S/N T20609669 N942RBJf Aviation LLC · Minot, NDBuilt 2005 · S/N T20608515

Back to AD 71-13-01 R1