Skip to content

Registered aircraft · 5,086

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:91-21-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:91-21-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:91-21-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:91-21-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:91-21-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:91-21-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.

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 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 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 N83ECCarter Associates Inc · Sturgis, MIBuilt 2000 · S/N 4636307 N83JFForker John S · Orcas, WABuilt 1995 · S/N LIV 192 N83PAHill Enterprise Inc · Wilmington, DEBuilt 1981 · S/N 31-8112050 N83RAPessoa Guiherme · Winter Garden, FLS/N 31-638 N83WCRegistered aircraftBuilt 1966 · S/N 27-3281 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 N841PSLivin The Dream Aviation LLC · Jupiter, FLBuilt 1967 · S/N 24-4684 N841WBQualitair LLC Trustee · MichelstadtBuilt 1978 · S/N 32R-7887075 N84219Manhattan Management Corp · Brooklyn, NYS/N 88 N8422PAnderson William · Creve Coeur, ILBuilt 1964 · S/N 24-3672 N8424ATringale Alison · Port Saint Joe, FLBuilt 1981 · S/N 32R-8129092 N84263Chadwick James B · Rch Palos Vrd, CABuilt 1981 · S/N 32R-8129094 N8426CHarper-Smith Michael · Tarzana, CABuilt 1976 · S/N 32R-7680114 N8427CMorgan Aviation LLC · Greensboro, NCBuilt 1981 · S/N 32-8124030 N8428PBertling Kevin M · Spring, TXBuilt 1964 · S/N 24-3675 N842TCWitte Transport LLC · West Plains, MOBuilt 2000 · S/N 18280841 N8430BTrident Aviation LLC · Bedford, NHBuilt 1981 · S/N 32R-8129097 N84337Kent East Inc · Wilmington, DES/N 32R-8129104 N8433AWoods Todd Ryan · Perry, OKBuilt 1981 · S/N 32-8124032 N8433YLomeli Rigoberto Orozco Jr · Longs, SCBuilt 1981 · S/N 32R-8129101

Back to AD 91-21-01 R1