Skip to content

Registered aircraft · 17,027

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:72-03-03-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3') 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:72-03-03-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3')
  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:72-03-03-R3')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3')
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.

N42539Lincoln Sport Parachute Club Inc · Lincoln, NEBuilt 1968 · S/N 18259065 N4253QFrog Av LLC · Brownstown, INBuilt 1971 · S/N 17260153 N42543Browne Hunter J · Woodacre, CABuilt 1968 · S/N 18259069 N42546Hogue Patrick L · Paso Robles, CABuilt 1968 · S/N 18259070 N42549Schutz Christopher J · Rock Springs, WYBuilt 1968 · S/N 18259072 N42550Byerley Mark S · Greenback, TNBuilt 1968 · S/N 18259073 N42554Cagle Kimberlee S · Houston, TXBuilt 1968 · S/N 18259075 N42556Quality Contractors LLC · Deary, IDBuilt 1968 · S/N 18259076 N42560Mallory Mark P Trustee · Independence, ORBuilt 1968 · S/N 18259077 N42564Williams Robert E · Clermont, GABuilt 1968 · S/N 18259079 N42565Pops Space LLC · Luther, OKBuilt 1968 · S/N 18259080 N42567C & T Aviation LLC · Seattle, WABuilt 1968 · S/N 18259081 N4256LStewart Stephanie J · Lakeland, GABuilt 1966 · S/N 17254325 N4256QBurnham Cessna N4256q LLC · Carr, COBuilt 1971 · S/N 17260156 N42572Modi Yogini · Homestead, FLS/N 18259084 N42576Larch Hill Laboratory LLC · Earlville, NYBuilt 1968 · S/N 18259087 N42577Buttered Landings LLC · Hutchinson, KSS/N 18259088 N42578Hodges James M Jr · Manchester, GABuilt 1968 · S/N 18259089 N42580Cox Bruce R · Brock, TXBuilt 1968 · S/N 18259091 N42591Mcferrin Clinton J · Kyle, TXBuilt 1968 · S/N 18259094 N42594Wunsch Larry K · Fond Du Lac, WIBuilt 1968 · S/N 18259095 N42599Avco Patrol LLC · Lyndon, KSBuilt 1968 · S/N 18259098 N4259LBrown Lawrence D · Memphis, TNBuilt 1966 · S/N 17254328 N425RBAkguc Cengiz · Lantana, TXBuilt 1962 · S/N 18254214 N42604Lawrie Daniel A · Mesa, AZBuilt 1968 · S/N 18259100 N42606Ramon Jose J · West Palm Beach, FLBuilt 1968 · S/N 18259101 N4260LTrueman Jeffrey A · Clear, AKBuilt 1966 · S/N 17254329 N4260QLevin Robert G · Roseburg, ORBuilt 1971 · S/N 17260160 N42615N42615 LLC · Shorewood, ILBuilt 1968 · S/N 18259107 N4261LCochrane Warren H Jr · Carabaset Vly, MEBuilt 1966 · S/N 17254330 N42623Boulware Randall R Trustee · Bolivar, MOBuilt 1968 · S/N 18259110 N42625Tull Matthew W · Niceville, FLBuilt 1968 · S/N 18259112 N42627Henry Mark A · Dickinson, TXS/N 18259114 N42631Ga Elite LLC · Camarillo, CABuilt 1968 · S/N 18259115 N4263LCox Dennis J · Beach City, TXBuilt 1966 · S/N 17254332 N42645Williams Ray H Jr Trustee · Austin, NVBuilt 1968 · S/N 18259120 N42647Glenwood Tank Facility LLC · Ramsey, MNBuilt 1968 · S/N 18259121 N42648Propwash 182 LLC · Visalia, CABuilt 1968 · S/N 18259122 N42649Skydive Harbor Springs Inc · Charlevoix, MIBuilt 1968 · S/N 18259123 N4264LMcguckin Michael C · Mesa, AZBuilt 1966 · S/N 17254333 N4264QAlbrecht Paul J · Mine Hill, NJBuilt 1971 · S/N 17260164 N42652West Dennis M · Lexington Park, MDBuilt 1968 · S/N 18259124 N42653Stockwell William · Dowagiac, MIBuilt 1968 · S/N 18259125 N42655Hawes Pamela M · Lancaster, MABuilt 1968 · S/N 18259126 N4265CHunt Delbert O · Dillon, MTBuilt 1968 · S/N 15068178 N4265L1515 Aviation LLC · Burleson, TXBuilt 1966 · S/N 17254334 N4265QParrish Aviation Flight Academy LLC · Southlake, TXS/N 17260165 N4266298x LLC · Caddo Mills, TXBuilt 1968 · S/N 18259128 N4266QMaxwell James B · Lewiston, IDBuilt 1971 · S/N 17260166 N42672Dowden Lairon W Jr · Nederland, TXBuilt 1968 · S/N 18259131

Back to AD 72-03-03 R3