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.

N6820GJensen Eric Gunnar · Ogden Dunes, INBuilt 1970 · S/N 15072320 N6821GMueller Carla I · Lexington, SCS/N 15072321 N6822GKnot Enough Airspeed LLC · Oshkosh, WIBuilt 1970 · S/N 15072322 N6823GLopes Gaston A · Dallas, TXBuilt 1970 · S/N 15072323 N6824RSquadron 5 Inc · Saratoga, CABuilt 1966 · S/N T210-0224 N6825FKieffer Jason M · Omaha, NEBuilt 1966 · S/N 15063425 N6825GRhodes Bruce A · Santa Cruz, CABuilt 1970 · S/N 15072325 N6826FJeppesen Thomas L · Stanton, MIBuilt 1966 · S/N 15063426 N6826GStar Voyages LLC · Kissimmee, FLS/N 15072326 N6827GBrooks Jeffrey C · Bridgeton, NJBuilt 1970 · S/N 15072327 N682ADDuncan Brian · Indianapolis, INBuilt 1971 · S/N 15072493 N6830RElizalde Carla Zankiz · Estero, FLBuilt 1967 · S/N T210-0230 N6832GAeronautical Technical Service Inc · Collierville, TNS/N 15072332 N6832RWheeler David G Jr · Chico, CAS/N T210-0232 N6834FLecompte Kevin J · Lancaster, MABuilt 1966 · S/N 15063434 N6834GRoberts Edwin G · Lake Wales, FLBuilt 1970 · S/N 15072334 N6836FFoley Anthony · Savannah, GABuilt 1966 · S/N 15063436 N6836GRegistration Pending · Highland, UTRegistration pendingBuilt 1970 · S/N 15072336 N6837FSkyberjet LLC · Allen, TXBuilt 1966 · S/N 15063437 N6840FBushre David · Janesville, WIBuilt 1966 · S/N 15063440 N6840GMiller Robert L · Tecumseh, MIBuilt 1970 · S/N 15072340 N6842FRodriguez Leyla M · Bellflower, CABuilt 1966 · S/N 15063442 N6843FMoyers John Jason · Midlothian, VAFirst renewal noticeBuilt 1966 · S/N 15063443 N6843GTracey Corp · Midland, VAS/N 15072343 N6843RArkansas Air LLC · Jackson, WYBuilt 1966 · S/N T210-0243 N6845FHoward Donald E II · Ponca City, OKBuilt 1966 · S/N 15063445 N6847FFranko Gregory · Grindstone, PABuilt 1966 · S/N 15063447 N6847RAlpine Aviation LLC · Oklahoma City, OKFirst renewal noticeBuilt 1967 · S/N T210-0247 N6848FWhitehead Mathew S · Leesville, LABuilt 1966 · S/N 15063448 N6849FDeangelis Jarrod A · Henderson, NVS/N 15063449 N684SSecond Wind Aviation Corp · Friday Harbor, WABuilt 1969 · S/N 20700147 N6850GVoorheis Patrica D · Casa Grande, AZBuilt 1970 · S/N 15072350 N6851FCarr Thomas W · Grand Blanc, MIBuilt 1966 · S/N 15063451 N6851R6851r LLC · Greeley, COS/N T210-0251 N6852RJensen Sid R · Idaho Falls, IDBuilt 1967 · S/N T210-0252 N6854GUniverse LLC · Prospect, KYBuilt 1970 · S/N 15072354 N6855RD & N Holdings Inc · Boca Raton, FLBuilt 1967 · S/N T210-0255 N6857GDuran Alexander · Holbrook, NYBuilt 1970 · S/N 15072357 N6857RRegistered aircraftBuilt 1967 · S/N T210-0257 N6859RRomeo Airmotive LLC · Stockton, CABuilt 1967 · S/N T210-0259 N685RADenkat Plane Shadow LLC · Buckeye, AZBuilt 1968 · S/N 15068701 N685SSecond Wind Aviation Corp · Friday Harbor, WABuilt 1970 · S/N 20700184 N6861RJohnson Bradley Michael · Belgrade, MTBuilt 1967 · S/N T210-0261 N6862FGradel Thomas A Jr · Irmo, SCBuilt 1966 · S/N 15063462 N6864RRankin Bryan · Cloverdale, CABuilt 1967 · S/N T210-0264 N6865FGeissler Robert William Jr · Baltimore, MDBuilt 1966 · S/N 15063465 N6866FLand Ross A · Cedar Rapids, IAS/N 15063466 N6866ROrnes W Harold · Aiken, SCBuilt 1967 · S/N T210-0266 N6868FVan Bielert Wouter · Haxtun, COS/N 15063468 N6868LJohnson Gregory L · Orange, CABuilt 1969 · S/N 18260147

Back to AD 72-03-03 R3