Skip to content

Registered aircraft · 20,483

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-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:84-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:84-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:84-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:84-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:84-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.

N3246EKauffman Gerald E · Bedford, PABuilt 1982 · S/N 18268239 N3246UGregory Group LLC · Norwalk, CTBuilt 1963 · S/N 18254646 N3248DPalmer Cade E · Eagle River, AKBuilt 1955 · S/N 32046 N3248SHanson Glen W · Anchorage, AKBuilt 1964 · S/N 18255748 N3249UHutchison Roger R · Sioux Falls, SDBuilt 1963 · S/N 18254649 N324RHPhillips William L Trustee · E Hampton, MABuilt 1979 · S/N 18267211 N324RJSchelhorn Timothy J · Nampa, IDS/N 18254601 N324RPClear For Take Off LLC · Burlingame, CABuilt 2004 · S/N 18281422 N324SVDavis Kyle R · Colleyville, TXBuilt 1980 · S/N R18201609 N324YCesscon LLC · Yalesville, CTBuilt 1976 · S/N 18264524 N3250U50 Uniform LLC · Traverse City, MIBuilt 1963 · S/N 18254650 N3250YEonm182 LLC · El Paso, TXBuilt 1962 · S/N 18254250 N3251DE S P Aviation LLC · Wilmington, DES/N 32049 N3251YCarlson Andrew J · Ashville, NYBuilt 1962 · S/N 18254251 N3252DQuigg Aircraft LLC · Muskegon, MIBuilt 1955 · S/N 32050 N3252SWhite Robert E · Woodlawn, TNBuilt 1964 · S/N 18255752 N3253SCobb Darrell V · Corsicana, TXBuilt 1964 · S/N 18255753 N3254SAllen John C · Austerlitz, NYBuilt 1964 · S/N 18255754 N3254UWright Ronald J · Olympia, WABuilt 1963 · S/N 18254654 N3255DAzul Aviation Inc · Fort Worth, TXS/N 32053 N3256YCowden Mark T · Kerrville, TXBuilt 1962 · S/N 18254256 N3257DAlaska Dall Sheep Guides LLC · Anchorage, AKBuilt 1955 · S/N 32055 N3257SFelton Frank B III · Thorndale, TXBuilt 1964 · S/N 18255757 N3257YGilbert Donald L Jr · Ligonier, PABuilt 1962 · S/N 18254257 N3258SRockwood Spa LLC · Houston, MOBuilt 1964 · S/N 18255758 N3258YByra Paula A · Pagosa Springs, COS/N 18254258 N3259DLutes Stacy J · Mooresville, NCBuilt 1955 · S/N 32057 N3259RGlobal Marc Aire Inc · Dallas, TXBuilt 1973 · S/N U20602215 N3259UMoore Christopher · Canton, PABuilt 1963 · S/N 18254659 N3259YGrantham William Edward · Doerun, GAS/N 18254259 N325DDQuick Michael D · Middletown, CAS/N 21062748 N325MMBirdie Aviation LLC · Marble Hill, GABuilt 2007 · S/N 18281907 N325SWSheroyair LLC · Sarasota, FLBuilt 2020 · S/N 18283097 N3260SAbner Aviation LLC · Advance, NCS/N 18255760 N3260YOneal Gary · Springdale, ARBuilt 1962 · S/N 18254260 N3261DCastorina John Salvatore · Anthem, AZBuilt 1955 · S/N 32059 N3261MDyas Chris · Fairhope, ALBuilt 1998 · S/N 18280347 N3261SBig Island Gravity LLC · Kapaau, HIS/N 18255761 N3262SIlair LLC · Manassas, VABuilt 1964 · S/N 18255762 N3263SBynum Albert L · Gadsden, ALBuilt 1964 · S/N 18255763 N3265DMiller Matthew S · Washougal, WABuilt 1955 · S/N 32063 N3265SZehntner David R · Labelle, FLBuilt 1964 · S/N 18255765 N3265UPreissler Daniel E · Giltner, NEBuilt 1963 · S/N 18254665 N3266UVingers Michael T · Dellwood, MNBuilt 1963 · S/N 18254666 N3267DDavidson Danny F · Anchorage, AKBuilt 1955 · S/N 32065 N3268CLane Ryan Auctions LLC · Palmyra, PAS/N R18200262 N3268SSquier Mark R · Lake Dallas, TXBuilt 1964 · S/N 18255768 N326CFWestbank Fishing LLC · Kiln, MSBuilt 2001 · S/N 18281045 N326MCJ&D Petroleum · Tallahassee, FLS/N 18281326 N326PSPsl Surveys · Greenville, DEBuilt 2012 · S/N 18282344

Back to AD 84-10-01 R1