Skip to content

Registered aircraft · 8,139

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:96-10-01-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:96-10-01-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:96-10-01-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:96-10-01-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:96-10-01-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:96-10-01-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.

N8402RLivengood Leasing Co LLC · Mesa, AZBuilt 1966 · S/N 28-22279 N8402WAnderson Thomas · La Quinta, CABuilt 1965 · S/N 28-2616 N8403RSenmounnarath Sam · Murfreesboro, TNBuilt 1966 · S/N 28-22280 N8405RShields Parker · Port Orange, FLBuilt 1966 · S/N 28-22345 N8405WTaylor Dale E · Kimball, SDBuilt 1965 · S/N 28-2621 N8406WWright Jordan M · York, SCBuilt 1965 · S/N 28-2623 N8408CDallas Secure Storage LLC · Dallas, ORBuilt 1976 · S/N 28-7625113 N8408RWilliams Christopher A · Kent, WAS/N 28-22285 N8409RRatliff Christopher · Manteno, ILBuilt 1966 · S/N 28-22286 N8409WMessam Andre · Snellville, GABuilt 1965 · S/N 28-2626 N8410WRenegade6 Aviation LLC · Woodbridge, VABuilt 1965 · S/N 28-2629 N8411REleven Romeo LLC · Golden, COBuilt 1966 · S/N 28-22288 N8411WHiggins Timothy Owen · Axtell, TXS/N 28-2635 N8412RChamberlain Richard T · Collinsville, ILBuilt 1966 · S/N 28-22289 N8412WSutton Timothy A · Glencoe, ALS/N 28-2636 N8413RZuniga Hector Javier · Mission, TXBuilt 1966 · S/N 28-22290 N8413WHollier Gregory J · Arnaudville, LABuilt 1965 · S/N 28-2637 N8414FPenley Robert G · Corinth, TXBuilt 1976 · S/N 28-7725111 N8414RVick Justin M · Morton Grove, ILBuilt 1966 · S/N 28-22291 N8414WOhmacht Carlton J · Glenwood, MNBuilt 1965 · S/N 28-2638 N8415RMahanna John A · Radcliff, KYBuilt 1966 · S/N 28-22348 N8416RExpert Staffing West Inc · Ramona, CABuilt 1966 · S/N 28-22293 N8416WCass Aviation LLC · North Las Vegas, NVBuilt 1965 · S/N 28-2642 N8417CDolan Joseph B · Baltimore, MDBuilt 1976 · S/N 28-7625114 N8418RCarlsson Carl J · Mason City, IABuilt 1966 · S/N 28-22295 N8418WMadison Mike · Pittsburg, TXBuilt 1965 · S/N 28-2644 N8419RLytle Cole · North Palm Beach, FLS/N 28-22296 N841BKKilpatrick Joseph C · Atlanta, GABuilt 1966 · S/N 28-3255 N841CMTalley-Sickles Jacqueline M · Oxnard, CAFirst renewal noticeBuilt 1969 · S/N 28-5488 N841EDR&D Aviation LLC · Fayetteville, GABuilt 1967 · S/N 28-4273 N8420RMueller Lance · Milton, DEBuilt 1966 · S/N 28-22349 N8420WMckee Shane D · Fairbanks, AKS/N 28-2647 N8421RRoberts Darren C · Zionsville, INBuilt 1966 · S/N 28-22298 N8422RTascarella William M · Quakertown, PABuilt 1966 · S/N 28-22299 N8422W642 Flying Club Of Fort Worth Inc · Fort Worth, TXBuilt 1965 · S/N 28-2649 N8423WGillanders Kenneth William · Carson City, NVBuilt 1965 · S/N 28-2650 N8425WBenner James R · Goshen, INBuilt 1965 · S/N 28-2652 N8426RBryant Bryce E · Evans City, PABuilt 1966 · S/N 28-22303 N8427RLopez Trinidad V · El Cajon, CAS/N 28-22305 N8428WAces High Aviation LLC · Casper, WYBuilt 1965 · S/N 28-2656 N8429WCleveland Tommy E · Mountain View, ARBuilt 1965 · S/N 28-2659 N842TTMartsolf Kenneth W · Gresham, ORBuilt 1966 · S/N 28-22350 N8430RRegistration Pending · Calera, OKRegistration pendingBuilt 1966 · S/N 28-22309 N8430WZuber Thomas P · Opelika, ALBuilt 1965 · S/N 28-2660 N8431WAhearn Bernard Francis · Farmington, NHS/N 28-2661 N8432CEmpire Aviation · Oxford, NCBuilt 1976 · S/N 28-7625117 N8432WBinek Darwin P · Midlothian, TXBuilt 1965 · S/N 28-2662 N8433RRichards Riley · Seattle, WABuilt 1966 · S/N 28-22313 N8433WKilduff James L · Wellsboro, PABuilt 1965 · S/N 28-2663 N8434RPeoples John R Jr · Hixson, TNS/N 28-22314

Back to AD 96-10-01 R1