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.

N3845RDelaney Patrick James · Marion, TXS/N 17255341 N3845Y1st Due Emergency Response Solutions LLC · Bartlett, KSS/N 21058345 N3846LElicker Sheldon L · Auburn, CABuilt 1966 · S/N 17254015 N3846RSampson Corey · Newnan, GABuilt 1966 · S/N 17255346 N3847JEscue James C · Brownsville, TNBuilt 1966 · S/N 15065147 N3847YLee Justin W · Maud, TXBuilt 1964 · S/N 21058347 N3848LHarrod Group Inc · Ellaville, GABuilt 1966 · S/N 17254017 N3848QWestwind Flyers LLC · Friday Harbor, WABuilt 1971 · S/N 17259948 N3848RGunter Jeffrey W · Demorest, GAS/N 17255348 N3849JGamble Marty · Crofton, KYBuilt 1966 · S/N 15065149 N3849QSmetana Louis V III · Blair, NEBuilt 1971 · S/N 17259949 N3849RSims Charles H · Soldotna, AKBuilt 1966 · S/N 17255349 N3850RKelley Patrick W · Charlo, MTBuilt 1966 · S/N 17255350 N3850YPoole Vernon N · Melstone, MTBuilt 1964 · S/N 21058350 N3851YMckie-Voerste Travis K · Chatsworth, GABuilt 1964 · S/N 21058351 N3852LMountain Wings LLC · Salem, WVBuilt 1965 · S/N 17254021 N3852QOwens Wilbur · Rch Palos Vrd, CAS/N 17259952 N3852RChristman Mike G · Wasilla, AKBuilt 1966 · S/N 17255352 N3853G3853g LLC · Umatilla, FLBuilt 1967 · S/N U206-0853 N3853YRafter Bar B LLC · Ashland City, TNBuilt 1964 · S/N 21058353 N3854QHafford Jay T · Stevenson, WAS/N 17259954 N3854YJames Wilson Smith Enterprises LLC · Athens, GABuilt 1964 · S/N 21058354 N3855GMoore David · Lexington, TXBuilt 1967 · S/N U206-0855 N3855JWiley Phillip W · New Martinsville, WVBuilt 1966 · S/N 15065155 N3855RAircraft Investment Group LLC · Cookeville, TNBuilt 1966 · S/N 17255355 N3856JClifton Chad R · Asheboro, NCBuilt 1966 · S/N 15065156 N3856LSimmons Brandon M · Sylacauga, ALS/N 17254025 N3856RSmith Joseph M · Juneau, AKBuilt 1966 · S/N 17255356 N3857RLorring Eric Henry · Kodiak, AKBuilt 1966 · S/N 17255357 N3857YLutz Matthew B · Jackson, TNBuilt 1964 · S/N 21058357 N3858QPylant Eric Jon · Arnold, CABuilt 1971 · S/N 17259958 N3859JOnefiftyjuliet LLC · Saint Petersburg, FLBuilt 1966 · S/N 15065159 N3859LBourke Michael T · Adams, WIBuilt 1965 · S/N 17254028 N3859RLeja Dennis A · Watertown, WIBuilt 1966 · S/N 17255359 N3859YMorse Donald W · Priest Lake, IDFirst renewal noticeS/N 21058359 N385CHL H Aviation LLC · Clanton, ALBuilt 1966 · S/N 17255354 N385TDHomestead Helicopters Inc · Missoula, MTBuilt 1965 · S/N T210-0072 N3860LLake Area Technical College · Watertown, SDBuilt 1965 · S/N 17254029 N3861LSeverson Marshall G · Anchorage, AKBuilt 1966 · S/N 17254030 N3861QLopez Mario J · Torrance, CABuilt 1971 · S/N 17259961 N3861RShawn James Robert · Pattison, TXS/N 17255361 N3861YMiller Todd D · Fort Wayne, INBuilt 1964 · S/N 21058361 N3862GRenfro Michael W · Bethel, AKS/N U206-0862 N3862JDoyle Ethan Mackenzie · Nunda, NYBuilt 1966 · S/N 15065162 N3862LSainsbury James L · Milton, WIBuilt 1965 · S/N 17254031 N3862QQ Flyers LLC · Anaheim, CABuilt 1971 · S/N 17259962 N3863QCondor Air LLC · Pleasant Valley, NYBuilt 1971 · S/N 17259963 N3863ROkeefe Dennis G · Cincinnati, OHBuilt 1966 · S/N 17255363 N3864QEvans James · Tuolumne, CAS/N 17259964 N3864RR Thimesch Construction LLC · Spivey, KSS/N 17255364

Back to AD 72-03-03 R3