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.

N6673FKysar Ian R · Battle Ground, WABuilt 1966 · S/N 15063273 N6674FBon Investment Holdings LLC · Zephyrhills, FLBuilt 1966 · S/N 15063274 N6674GJoe Dory Aviation LLC · Caldwell, IDBuilt 1970 · S/N 15072174 N6675FCommercial Center Inc · Wilmington, DEBuilt 1966 · S/N 15063275 N6676FCampbell J R Jr · Bell, FLBuilt 1966 · S/N 15063276 N6676GChen Hong · Independence, ORBuilt 1970 · S/N 15072176 N6679SCampos Katherine · Tallahassee, FLBuilt 1967 · S/N 15067479 N667WBMcleod Patrick J · Overgaard, AZBuilt 1967 · S/N 18258563 N6681GMoore Joseph L · Hesperus, COS/N 15072181 N6683GPardee Gary D · Buckley, WABuilt 1970 · S/N 15072183 N6683SWingsofdawn LLC · East Greenwich, RIBuilt 1967 · S/N 15067483 N6684GReeder Brenton Lamar · Beacon, NYBuilt 1970 · S/N 15072184 N6687FBlakesley Eric R · Canandaigua, NYS/N 15063287 N6687SSale Reported · Houston, AKSale reportedBuilt 1967 · S/N 15067487 N6689FMills Nicolas A · Greenwood, NYBuilt 1966 · S/N 15063289 N6689SSimpson Dwight D · Phillips, WIBuilt 1967 · S/N 15067489 N6690SSeniram Air Inc · Wilmington, DEBuilt 1967 · S/N 15067490 N6692GHopkins Marissa A · Cameron, MTBuilt 1970 · S/N 15072192 N6692SNoltensmeyer Kurt Jon · Greenbank, WABuilt 1967 · S/N 15067492 N6694FWanagel Walter · Lisbon, CTBuilt 1966 · S/N 15063294 N6694GChatas John W · Ann Arbor, MIS/N 15072194 N6695SOlsen Raymond E · Washington, UTBuilt 1967 · S/N 15067495 N6696FYoung Deborah C · Lopez Island, WABuilt 1966 · S/N 15063296 N6696SJohnson Jay E · Murray, IABuilt 1967 · S/N 15067496 N6697FLogan Thomas H · Canfield, OHS/N 15063297 N6697GPaul William A · Windfall, INS/N 15072197 N6699GBailey Matthew T · Cornelius, ORBuilt 1970 · S/N 15072199 N669GAWilson Victor A · New Albany, OHS/N R172-0200 N669JKGeddes Michael · Seattle, WAS/N 15068277 N669SRCabot Scott R · Cross Plains, WIBuilt 1970 · S/N 18260492 N66BTTrazer LLC · Parkland, FLBuilt 1964 · S/N 21058437 N66DTTucker Family Agricultural Co LLC · Kiowa, KSS/N 21058931 N66RXRegistered aircraftBuilt 1962 · S/N 18253766 N6700SAgape Enterprises · Montana City, MTBuilt 1967 · S/N 15067500 N6700TKimmerle David · Blanding, UTBuilt 1963 · S/N 18254862 N6701FHale James W · Darrington, WAS/N 15063301 N6701SKnipping Richard W Jr · Winterport, MEFirst renewal noticeBuilt 1967 · S/N 15067501 N67022Mccormack James · Mount Jewett, PABuilt 1970 · S/N 17259032 N6702FVirnig Joshua B · Deerwood, MNBuilt 1966 · S/N 15063302 N6703FBargabos Julie A · Canastota, NYBuilt 1966 · S/N 15063303 N6703RSteinle Lee M · Jourdanton, TXBuilt 1966 · S/N T210-0103 N6704FAvistar Media Corporation · Wilmington, DES/N 15063304 N6704GRyan Conner J · Fruita, COS/N 15072204 N6705SMiszczak Ethan · Newnan, GABuilt 1967 · S/N 15067505 N6706RSzopa Ireneusz W · East Troy, WIBuilt 1965 · S/N T210-0106 N6706SDavis Bradley · Oconomowoc, WIBuilt 1967 · S/N 15067506 N6707RParker David Scott Trustee · Albuquerque, NMBuilt 1965 · S/N T210-0107 N6708GRussell Gary W · Martinsburg, WVBuilt 1970 · S/N 15072208 N6710GShelton Dale E · West Frankfort, ILBuilt 1970 · S/N 15072210 N6712RAero Applications Inc · Burley, IDBuilt 1966 · S/N T210-0112

Back to AD 72-03-03 R3