Skip to content

Registered aircraft · 40,473

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

N55671Brown Christopher A · Tigard, ORBuilt 1973 · S/N 28-7305440 N55673Smith Gordon H · Racine, WIBuilt 1973 · S/N 28-7305442 N55675Sykes Kinsley · Palm Coast, FLBuilt 1973 · S/N 28-7305443 N5567MAnderson Layne A · Wichita Falls, TXBuilt 1967 · S/N 092 N5567QRicol Aviation LLC · Naples, FLBuilt 1965 · S/N 2972 N5567W3k Weavers Investment Group LLC · Shelbyville, KYBuilt 1962 · S/N 28-661 N55680Madsen Pest Management LLC · Siren, WIBuilt 1973 · S/N 28-7325466 N55687Rieber Russell C · Stockton, CABuilt 1973 · S/N 28-7305444 N5568PSimon Jack · Spring Hill, TNBuilt 1958 · S/N 24-632 N5568WRegistration Pending · Lebanon, INRegistration pending, pending cancellationS/N 28-662 N55691Brown Alan · Lugoff, SCS/N 28-7305447 N5569MWichita Flight Training LLC · Wichita, KSBuilt 1967 · S/N 079 N5569QBrian C Elbert · Rochester, NHBuilt 1965 · S/N 2973 N5569UJapikse Bert · Pawleys Island, SCBuilt 1970 · S/N 28-26884 N5569WBridges Michael D · Clovis, NMBuilt 1962 · S/N 28-663 N556FLKarg Asset Management LLC · Pocahontas, ARS/N 28-7125395 N556JRSemmig Jeffrey C · Oceanside, CABuilt 1987 · S/N 1144 N556MKurdzel Mark A · Chattanooga, TNS/N 10150 N556PAAviator Corp · Wilmington, DEBuilt 1972 · S/N 28-7225477 N556PCChristiansen Aviation LLC · Wilmington, DEBuilt 2001 · S/N 4496074 N556PSPotter Mark W · Portland, ORBuilt 1998 · S/N 124 N556SHNovember Alpha LLC · Dover, DEBuilt 2004 · S/N 3581 N55701Level Up Aviation LLC · Newton, ALBuilt 1973 · S/N 28-7325460 N55702Seay Horace M · Desoto, TXBuilt 1973 · S/N 28-7325461 N55706Camp Justin P · Edwall, WABuilt 1973 · S/N 28-7305448 N5570FCherokee Adventure Corp · Wilmington, DEBuilt 1968 · S/N 28-25006 N5570MFlythebat.Com LLC · Chicago, ILBuilt 1967 · S/N 135 N5570URegistration Pending · Mesa, AZRegistration pendingBuilt 1969 · S/N 28-26299 N55716Norby Aviation LLC · Hopkinton, MABuilt 1973 · S/N 28-7325465 N55719Coffey County Airport · Burlington, KSBuilt 1973 · S/N 287325467 N5571MEdwards Larry N · Saint Joseph, MOBuilt 1967 · S/N 105 N5571QBerry Charles P · Monroe, NCBuilt 1965 · S/N 2974 N5571VColeman Douglas E · Tallahassee, FLBuilt 1959 · S/N 23-1784 N55722Cactus Aero LLC · Haslet, TXBuilt 1973 · S/N 28-7305451 N55724Parker David G · Bristol, TNBuilt 1973 · S/N 28-7305452 N5572UPoor Farmer Aviation LLC · Saint Marys, OHBuilt 1969 · S/N 28-26302 N5572VWood Charles S · Fox Island, WABuilt 1977 · S/N 28-7725241 N55730K&D Ip LLC · Chicago, ILBuilt 1973 · S/N 28-7325468 N55731Leary Dennis E · Chesapeake Beach, MDBuilt 1973 · S/N 28-7325469 N55736Fox Ralph W II · Wilmington, NCBuilt 1973 · S/N 28-7305373 N55738Wenner William E · Kechi, KSBuilt 1973 · S/N 28-7325473 N55739Kepfer Robert · Felton, DEBuilt 1973 · S/N 28-7305456 N5573QAthens Neurology Professional Association · Athens, TXBuilt 1965 · S/N 2975 N5573WHokanson Elijah R · Ashby, MNS/N 28-668 N55742Doyal William T · Visalia, CABuilt 1973 · S/N 28-7325474 N55743B&R Aircraft LLC · Wadsworth, OHBuilt 1973 · S/N 28-7325475 N55744Williams Mike · Hartsville, INS/N 28-7325476 N55746Mccoy Michael E · Sanford, NCBuilt 1973 · S/N 28-7305459 N5574MSimpson David B · Oakhurst, CABuilt 1967 · S/N 108 N5574PPluck Mervyn M · Glendora, CABuilt 1958 · S/N 24-638

Back to AD 80-04-03 R2