Skip to content

Registered aircraft · 17,028

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.

N854AJLowe David · Sacramento, KYS/N 15065832 N8551SOpticalx LLC · Tracy, CAS/N 18256651 N8551UFishman Randall · Napanoch, NYBuilt 1964 · S/N 17252451 N8552SRtd Farm Inc · Fort Benton, MTBuilt 1965 · S/N 18256652 N8553JMindy Limited LLC · Muscatine, IABuilt 1967 · S/N 15066453 N8553UFinley Todd R · Carmel, INBuilt 1965 · S/N 17252453 N8554UWorkman David A · Putnam, ILBuilt 1965 · S/N 17252454 N8555JBauer Walter G · Neenah, WIBuilt 1967 · S/N 15066455 N8555SBray Harvey G · Reidsville, NCBuilt 1965 · S/N 18256655 N8555ULeaf Sport LLC · Henning, MNBuilt 1965 · S/N 17252455 N8556SRoyalty Marshall E · Seymour, INBuilt 1965 · S/N 18256656 N8557GDoddi Vikram · Austin, TXBuilt 1965 · S/N 15062657 N8557JRobertson Billy J Trustee · Cleveland, OKBuilt 1967 · S/N 15066457 N8557SLittle River Aviation LLC · Tifton, GABuilt 1965 · S/N 18256657 N8557UOconnor Jonathan D · East Aurora, NYS/N 17252457 N8558UNelson David R · Stanwood, WABuilt 1965 · S/N 17252458 N8559GAeronautical Technical Service Inc · Collierville, TNS/N 15062659 N8559SHanson Robert J · Renton, WABuilt 1965 · S/N 18256659 N855JWButterfield Rory A · Milan, NMS/N 15071147 N855TWMapes Peter B · Oscoda, MIS/N 15065657 N8561GFox Harvey · Lititz, PABuilt 1965 · S/N 15062661 N8561USmith Michael V · Fort Myers, FLBuilt 1964 · S/N 17252461 N8562UMall Craig S · Dingmans Ferry, PABuilt 1965 · S/N 17252462 N8563JTschepen Leo R · Bisbee, NDBuilt 1967 · S/N 15066463 N8563UCanupp Joseph J · Clinton, SCBuilt 1964 · S/N 17252463 N8565GFreedom Flight Service LLC · Glendale, AZBuilt 1965 · S/N 15062665 N8566GEluwawalage Damayanthie · Reading, PABuilt 1966 · S/N 15062666 N8566SVon Borstel Alan W · Grass Valley, ORBuilt 1965 · S/N 18256666 N8567UPfeiffer Rebecca M · Independence, MNBuilt 1964 · S/N 17252467 N8568GSkeen Harry K · Philippi, WVBuilt 1966 · S/N 15062668 N8568QSkyhawk Aero LLC · Montevideo, MNBuilt 1967 · S/N 17255780 N8570GGreenville Pilots Association Eaa Chapter 1382 · Greenville, ILS/N 15062670 N8570JBitikofer Brent · Kansas City, KSS/N 15066470 N8571JRoam Gary A · Venice, FLBuilt 1967 · S/N 15066471 N8571SStevenson Intermountain Seed Inc · Ephraim, UTBuilt 1965 · S/N 18256671 N8571UBell Charles M DBA · Warsaw, NYBuilt 1965 · S/N 17252471 N8572RReese Owein · Glen Rock, NJBuilt 1964 · S/N 205-0549 N8572SPaulan Beverly S · Antioch, ILBuilt 1965 · S/N 18256672 N8573GFichtner Eric Lowell Russell · Concord, NCS/N 15062673 N8573S182 Flight Corp · Bronx, NYBuilt 1965 · S/N 18256673 N8574JHubenthal William L · Carbondale, ILBuilt 1967 · S/N 15066474 N8575GAero Services Lc · Woods Cross, UTS/N 15062675 N8575SDallas William J · Eastsound, WABuilt 1965 · S/N 18256675 N8575UVermillion County Flying Club · Danville, ILBuilt 1965 · S/N 17252475 N8576GSchaefer John · Liberty Hill, TXBuilt 1966 · S/N 15062676 N8577GLakey Robert E · Arlington, TXBuilt 1965 · S/N 15062677 N8577SRegistration Pending · Concord, GARegistration pendingBuilt 1965 · S/N 18256677 N8578JParagon Aviation LLC · Reading, PABuilt 1967 · S/N 15066478 N8579SHopp Gregory R · Columbus, OHBuilt 1965 · S/N 18256679 N8579UStueckradt Steve · Ankeny, IABuilt 1965 · S/N 17252479

Back to AD 72-03-03 R3