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.

N8406UGrzincich Michael J · Coon Rapids, MNBuilt 1964 · S/N 17252306 N8406ZBarsto Aviation Inc · Wilmington, DEBuilt 1963 · S/N 205-0406 N84071Roadrunner Flight School LLC · Farmington, NMBuilt 1969 · S/N 17258322 N84072Ferre Taylor · Kirkland, WABuilt 1969 · S/N 17258323 N84076Third Step 3 LLC · Gilbert, AZBuilt 1969 · S/N 17258325 N8407LPlainwell Aviation And Stem Academy · Kalamazoo, MIBuilt 1968 · S/N 17256607 N8407MJohnson Michele J · Buena Vista, COBuilt 1969 · S/N A1500107 N8407SRottinghaus Charles A · Waterloo, IABuilt 1965 · S/N 18256507 N84082Weinheimer Paul T · Amarillo, TXBuilt 1969 · S/N 17258326 N84086Smoky Mountain Flyers · Murphy, NCBuilt 1969 · S/N 17258327 N8408UMastey Patrick R · Saint Cloud, MNS/N 17252308 N8408ZRegistered aircraftBuilt 1963 · S/N 205-0408 N84092Brown Stephen J · Chandler, AZBuilt 1969 · S/N 17258328 N84093Hruska Coyle J · Lime Springs, IABuilt 1969 · S/N 17258329 N84097Argoudelis Michael · Kalamazoo, MIS/N 17258331 N8409GOberholzer Craig C · Stanley, NCS/N 15062509 N8409LRegistered aircraftBuilt 1968 · S/N 17256609 N8409SKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1965 · S/N 18256509 N84104Morris Daniel B · Ankeny, IABuilt 1969 · S/N 17258334 N84105Jost Jared D · Hillsboro, KSS/N 17258335 N84108Bramblett John S · Russellville, ARBuilt 1969 · S/N 17258337 N8410J1st Flight LLC · Allentown, PABuilt 1967 · S/N 15066310 N8410LVictory Lane Aviation LLC · Concord, NCBuilt 1968 · S/N 17256610 N8410MJr Imaging Logistics Inc · Pasco, WAS/N A15000110 N8410UMcbride Robert D · Buffalo, WYBuilt 1964 · S/N 17252310 N8410ZA1 Aviation Group Inc · Geneva, FLS/N 205-0410 N84114Miami Seaplane Tours Inc · Miami, FLBuilt 1969 · S/N 17258339 N84117Mendez Arturo · Addison, ILBuilt 1969 · S/N 17258340 N8411MGroce Austin L · Lebanon, TNS/N A1500111 N8411UNeu Aviation LLC · Benton, LABuilt 1964 · S/N 17252311 N8411ZJim Davis Enterprises Co · Wintersville, OHBuilt 1963 · S/N 205-0411 N84122Millican Marc J · Anchorage, AKBuilt 1969 · S/N 17258342 N84125Koenig Aircraft Restoration Inc · Loranger, LABuilt 1969 · S/N 17258343 N84129Petschow Kenneth W · Upland, CABuilt 1969 · S/N 17258344 N8412GMiller Charles V · High Point, NCBuilt 1965 · S/N 15062512 N8412JMckeon Michael F · Warren, MEBuilt 1967 · S/N 15066312 N8412LAddison Flying LLC · Addison, NYBuilt 1968 · S/N 17256612 N8412SWaldron Roger H · Santa Barbara, CABuilt 1965 · S/N 18256512 N8412U8 For 9 LLC · Scotia, NYBuilt 1965 · S/N 17252312 N84130Gutierrez Sergio E · Pharr, TXBuilt 1969 · S/N 17258345 N84133Registration Pending · Bowman, NDRegistration pendingS/N 17258347 N8413JGrimaldos Juan P · Fairbanks, AKBuilt 1967 · S/N 15066313 N8413LRussell Adam G · Easton, MES/N 17256613 N8413SFlying Condors Inc · Templeton, CABuilt 1965 · S/N 18256513 N84140Kaiser Joe E · Anchorage, AKBuilt 1969 · S/N 17258351 N84141Registration Pending · Mansfield, OHRegistration pendingBuilt 1969 · S/N 17258352 N84143Jones Donald T · Barrigada, GUS/N 17258353 N84146Stone Air LLC · Carrollton, GABuilt 1969 · S/N 17258354 N84147Cox James O II · Shady Shores, TXBuilt 1969 · S/N 17258355 N8414GKendallville Flying Service Inc · Saint Joe, INBuilt 1965 · S/N 15062514

Back to AD 72-03-03 R3