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.

N678GHHamilton Gilbert R · Leesburg, VABuilt 1977 · S/N 177RG1283 N678WLanghoff John A · Yoakum, TXBuilt 1969 · S/N 18259757 N6790GMartin Christopher G · Monessen, PABuilt 1970 · S/N 15072290 N6790SHildreth Jon R · Spencer, WVBuilt 1967 · S/N 15067590 N6792FPatton Aviation LLC · Billings, MTBuilt 1966 · S/N 15063392 N6792SJohnston Robert G · Rose Hill, KSBuilt 1967 · S/N 15067592 N6793FOgden John T · Meridian, IDBuilt 1966 · S/N 15063393 N6793GExecutive Flight Institute LLC · Murrieta, CABuilt 1970 · S/N 15072293 N6793RDelevie Mark Y · Tucson, AZBuilt 1966 · S/N T210-0193 N6794GLawson Kurt J · Melbourne, FLBuilt 1970 · S/N 15072294 N6796GLyon Scott T · Wellsville, KSBuilt 1970 · S/N 15072296 N6796SRegistration Pending · Lawrence, KSRegistration pendingS/N 15067596 N6797FGriswold M Dallas · Cordele, GABuilt 1966 · S/N 15063397 N6797RJts Management Inc · Lincoln, NEBuilt 1966 · S/N T210-0197 N6798GCowan Ronnie C · Glasgow, KYS/N 15072298 N6799GWetzler Brian · Bainbridge Island, WABuilt 1970 · S/N 15072299 N6799SAdr Aircraft Service Inc · Burbank, CABuilt 1967 · S/N 15067599 N679DLBlink Squirrel Aviation LLC · Cherokee, IABuilt 1970 · S/N 17259138 N679JTAdventure Aviation Sales Inc · Jeffersonville, INBuilt 1976 · S/N 17702428 N67BL206 LLC · Keizer, ORBuilt 1967 · S/N P206-0397 N67CNPrichard Brian E · Caledonia, MIBuilt 1968 · S/N 17257566 N67GRQuinlan Sherman L · Georgetown, TXBuilt 1966 · S/N 15064854 N67JMEck Gary A · Osceola, INBuilt 1973 · S/N 17701940 N67KEGran Tulley Corp · Arcadia, FLBuilt 1967 · S/N 18257834 N67MMSingh Ravinder · Happy Valley, ORBuilt 1975 · S/N 17702269 N67RAKirkwood Billie R · El Paso, TXS/N R172-0090 N67RVHopman Richard G · Oxford, MIBuilt 1966 · S/N 17255157 N67WJBusiness As Usual LLC · Spartanburg, SCBuilt 1973 · S/N 15074915 N67WTHenderson Ronald W · Marietta, OHBuilt 1968 · S/N 18259488 N6801GDelta Ridge Farms LLC · Oak Grove, LAS/N 15072301 N6802FMccall Freddie W Jr · Brewton, ALBuilt 1966 · S/N 15063402 N6802GFry John W · Vinita, OKBuilt 1970 · S/N 15072302 N6802RStahla Robert E Trustee · Grand Island, NEBuilt 1966 · S/N T210-0202 N6803FBenson George R · Woodlake, CABuilt 1966 · S/N 15063403 N6803RN6803r LLC · Kent, OHBuilt 1966 · S/N T210-0203 N6805FGoodner Brian C · Brookston, INBuilt 1966 · S/N 15063405 N6806FWeakland Christopher · Halifax, VABuilt 1966 · S/N 15063406 N6806GHigley Paul D · Redding, CABuilt 1970 · S/N 15072306 N6807GOriginal Design Ministries DBA · Eatonville, WABuilt 1970 · S/N 15072307 N6808GJewell Daniel J · Texarkana, ARS/N 15072308 N6809FCarlson Christian A L · Orange City, FLBuilt 1966 · S/N 15063409 N680JFDunham Transport Inc · Wannaska, MNBuilt 1966 · S/N 17255246 N680RSoule Nathan A · Croswell, MIS/N 18258380 N6810FAviation Trust Co LLC Trustee · Oklahoma City, OKS/N 15063410 N6811GPearce Douglas S · Belleville, MIBuilt 1970 · S/N 15072311 N6812GJannus Air Inc · Tampa, FLS/N 15072312 N6813FBuffalo Aviation LLC · Royal, NES/N 15063413 N6815FRemus Joseph D · Plano, TXFirst renewal noticeBuilt 1966 · S/N 15063415 N6818FBell Douglas W · Mattoon, ILBuilt 1966 · S/N 15063418 N6819GJ & J Holdings LLC · Warren, MIBuilt 1970 · S/N 15072319

Back to AD 72-03-03 R3