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.

N834HPNewman Aviation Services Inc · Tiffin, OHBuilt 2006 · S/N 3257426 N8355HLjmf 17 LLC · Hays, KSBuilt 2001 · S/N 3257204 N8355XSkyway Leasing Co Inc · Yakima, WABuilt 1981 · S/N 32R-8129053 N8359MColeman Russell L · Port Charlotte, FLBuilt 1981 · S/N 32-8124019 N8359SSoda Aviation LLC · Lexington, KYBuilt 1981 · S/N 32-8124020 N8360GSophamike Aviation LLC · Hattiesburg, MSBuilt 1981 · S/N 32R-8129057 N83615Brown Thomas E · Union Grove, ALBuilt 1981 · S/N 32R-8129058 N8366PBurris Robert V · Charlotte, NCBuilt 1964 · S/N 24-3624 N8367CBuckwalter Daniel E · Homer, AKBuilt 1976 · S/N 32-7640061 N8368COchoa Luis M · Hollywood, FLBuilt 1976 · S/N 32R-7680102 N836MCRobec LLC · Satanta, KSS/N T18208835 N836TSSchultz Robert J · Mountain View, CABuilt 2026 · S/N T18209205 N8375CHammett Jeb Stuart · Monroe, LABuilt 1976 · S/N 32R-7680103 N83808Jcl Aviation Inc · Palm Harbor, FLBuilt 1981 · S/N 32R-8129065 N8381VAurora Direct LLC · West Linn, ORBuilt 1981 · S/N 32-8124025 N8383PWhatley Mark · Orion, MIBuilt 1964 · S/N 24-3642 N8384CMountain Flying Adventures LLC · Missoula, MTBuilt 1976 · S/N 32R-7680105 N8384LMaring Inc · Blaine, MNBuilt 1981 · S/N 32R-8129054 N8386HSierra Aero · Carson City, NVBuilt 1981 · S/N 32R-8129067 N83894Sale Reported · Grangeville, IDSale reportedBuilt 1981 · S/N 32-8124029 N838CGGiger Gale · Austin, TXBuilt 2006 · S/N 27-0343 N8392PVaughn Charles P · Inverness, FLBuilt 1964 · S/N 24-3652 N8393XAeroforge LLC · Crystal Lake, ILBuilt 1981 · S/N 32R-8129074 N8396JCurtsinger Joseph C Jr · Nolensville, TNBuilt 1981 · S/N 32R-8129075 N839SAUS Department Of Homeland Security · Washington, DCBuilt 2003 · S/N T20608391 N83BFHayssen Arthur H · Sebastopol, CABuilt 1976 · S/N 27-7654171 N83BPBluebird Aircraft LLC · Austin, TXBuilt 2012 · S/N T20609042 N83ECCarter Associates Inc · Sturgis, MIBuilt 2000 · S/N 4636307 N83JFForker John S · Orcas, WABuilt 1995 · S/N LIV 192 N83LLGaard Vibeke S · Denver, COBuilt 2006 · S/N T18208511 N83PAHill Enterprise Inc · Wilmington, DEBuilt 1981 · S/N 31-8112050 N83PKFlugzeug LLC · Rancho Santa Fe, CABuilt 2022 · S/N T18209101 N83RAPessoa Guiherme · Winter Garden, FLS/N 31-638 N83VSTvpx Aircraft Solutions Inc · North Salt Lake, UTBuilt 2024 · S/N 4636846 N83WCRegistered aircraftBuilt 1966 · S/N 27-3281 N83WHLavino Edwin II · Laguna Niguel, CABuilt 2009 · S/N T18208968 N84008Harkey Wesley · Sherrills Ford, NCBuilt 1981 · S/N 28R-8131145 N8401DDarwin D Pluid · Eureka, MTBuilt 1981 · S/N 32R-8129076 N8403DTelford Aircraft LLC · Telford, TNS/N 32R-8129078 N8403PNewell Douglas Bryon · Sedalia, MOBuilt 1964 · S/N 24-3659 N8404PRegistration Pending · Pittsburgh, PARegistration pending, pending cancellationBuilt 1964 · S/N 24-3660 N8405PCarlin Chad P · San Juan Capistron, CAS/N 24-3661 N8408PBeavers Jeffrey · Metairie, LABuilt 1964 · S/N 24-3664 N8409HAerocolibri LLC · Nampa, IDBuilt 1981 · S/N 32R-8129084 N8409YRivera William Carl · Silver Spring, MDBuilt 1981 · S/N 32R-8129086 N8417P250 Dash 4 Associates Ltd · Yellow Springs, OHBuilt 1964 · S/N 24-3669 N841ADCedar Real Estate Inc · Anaheim, CABuilt 1973 · S/N 32-7340079 N841ATLuxury Transportation LLC · Talladega, ALBuilt 2004 · S/N 3257352 N841DMGibb David J · Dublin, OHBuilt 2006 · S/N T18208632 N841PSLivin The Dream Aviation LLC · Jupiter, FLBuilt 1967 · S/N 24-4684

Back to AD 71-13-01 R1