Skip to content

Registered aircraft · 5,075

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:84-19-03-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-19-03-R1') 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:84-19-03-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-19-03-R1')
  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:84-19-03-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-19-03-R1')
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.

N8903PBeyer Marvin A Jr · Taft, TXBuilt 1966 · S/N 24-4358 N8905NHigh Noon Leasing LLC · Anchorage, AKS/N 32-40690 N8905PBulle Jason L · Phoenix, AZBuilt 1966 · S/N 24-4360 N8906PComanche Inc · Leoti, KSBuilt 1966 · S/N 24-4361 N8907NCrain Roan · Cookeville, TNS/N 32-40693 N8908NH & H Aviation LLC · Provo, UTBuilt 1969 · S/N 32-40695 N8909NKrull Doug · Hendersonville, TNS/N 32-40696 N890HMarc Inc · Bolton, MSBuilt 1980 · S/N 31-8052194 N8910KCoulter Ts LLC · Midway, UTBuilt 1977 · S/N 32-7840046 N8910NRam Aeronautics LLC · Wichita Falls, TXBuilt 1969 · S/N 32-40698 N8910PComanche LLC · Peachtree City, GABuilt 1966 · S/N 24-4365 N8911PVarga Craig S · Chino Valley, AZBuilt 1966 · S/N 24-4366 N8914NTreetop Flyers LLC · Vashon, WABuilt 1969 · S/N 32-40704 N8914WDines Stephen R · Monument, COBuilt 1964 · S/N 28-10483 N8915PLegacy Aviation Mid-Michigan LLC · Kalamazoo, MIBuilt 1966 · S/N 24-4370 N8916NBundy Richard · Little Egg Harbor, NJBuilt 1969 · S/N 32-40707 N8917PLogsdon James C · Hanford, CABuilt 1966 · S/N 24-4372 N8918NStratton Erin B · Baton Rouge, LABuilt 1969 · S/N 32-40711 N891AWColonial Aviation LLC · Morristown, NJBuilt 1989 · S/N 4622024 N891CBKal-1 LLC · Wichita, KSBuilt 1980 · S/N 31-8012064 N8921POwens Gregory E · Kendallville, INBuilt 1966 · S/N 24-4377 N8922NKew Malcolm M · Hercules, CABuilt 1969 · S/N 32-40717 N8923NMiller Jarred J · Burton, OHBuilt 1969 · S/N 32-40718 N8924NRobinson Andrew · Auburn, CABuilt 1969 · S/N 32-40720 N8925NMackay James R · Corunna, MIS/N 32-40721 N8925PGriffith James E · Gig Harbor, WABuilt 1966 · S/N 24-4381 N8927NHoffman Gary D · Spencer, NEFirst renewal noticeBuilt 1969 · S/N 32-40724 N8928PGeorg John B · La Crosse, KSBuilt 1966 · S/N 24-4384 N892MMWings Of Dubuque LLC · Dubuque, IABuilt 1980 · S/N 31-8112029 N892RCSmw-Cjh Corp · Wilmington, DEBuilt 1966 · S/N 24-4379 N892TGTeo Steel Inc · Ramer, TNBuilt 1980 · S/N 31-8012053 N892TWTeo Steel Inc · Ramer, TNBuilt 1978 · S/N 31-7812111 N8931PDuncan Michael J · Cordova, TNBuilt 1966 · S/N 24-4387 N8932P260b LLC · San Diego, CABuilt 1966 · S/N 24-4388 N8936PGesenhues Bernard J · Canton, OHBuilt 1966 · S/N 24-4392 N8937NSchewe William M · Greenville, ILFirst renewal noticeBuilt 1969 · S/N 32-40735 N8939NOakley William J · Kildeer, ILBuilt 1969 · S/N 32-40741 N893CBAec Navajo LLC · Wilmington, DES/N 31-8012007 N8940PDavie Andrew S · Stony Point, NYBuilt 1966 · S/N 24-4396 N8942NMinnema Samuel S · Fairbanks, AKS/N 32-40742 N8942PAncelet Grant D · Crowley, LABuilt 1966 · S/N 24-4398 N8943NChase-Six LLC · Orange Park, FLBuilt 1969 · S/N 32-40744 N8946PBreding Ralph E · American Falls, IDBuilt 1966 · S/N 24-4402 N8947NGarfield Air LLC · Burwell, NEBuilt 1970 · S/N 32-40921 N8948NC6 Flying LLC · North Logan, UTBuilt 1970 · S/N 32-40750 N894ARLayke Tool And Manufacturing Co · Meadville, PABuilt 1989 · S/N 27-0034 N894MRAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2005 · S/N T20608576 N8950NWatson Richard D · Plant City, FLS/N 32-40751 N8951PJames Donnie E · Collinsville, ALBuilt 1966 · S/N 24-4408 N8952NCircle K Supply Chain Solutions LLC · Knoxville, TNBuilt 1969 · S/N 32-40754

Back to AD 84-19-03 R1