Skip to content

Registered aircraft · 68,375

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:90-04-06-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:90-04-06-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:90-04-06-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:90-04-06-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:90-04-06-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:90-04-06-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.

N353ACHoffberger Bruce S · Baltimore, MDBuilt 1998 · S/N 2843161 N353BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2024 · S/N 2881747 N353BHHeath Robert F · Lantana, TXBuilt 2007 · S/N 90114 N353CMIsland Air Taxi LLC · Put In Bay, OHBuilt 1976 · S/N 28-7725123 N353EKKrueger Eric L · New Marlborough, MABuilt 2019 · S/N 73987 N353JLMartinez Jose L · Kansas City, MOBuilt 1968 · S/N 17256727 N353LSDavidson Erick M · Piedmont, CABuilt 1999 · S/N 21081C N353MKNorth Star Aviation · Mankato, MNBuilt 2021 · S/N 2881442 N353RDGerlach Brett C · American Fork, UTBuilt 1995 · S/N 794-320-636 FB N353SBurdick Steven David · Saint Paul, MNBuilt 1968 · S/N 28R-30851 N353ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881643 N35401American Aviation Training LLC · Fort Scott, KSBuilt 1968 · S/N 17256748 N35402Kautzsch Randy D · Pocatello, IDBuilt 1968 · S/N 17256749 N35406Dennis Robert W Jr · Heath, OHBuilt 1968 · S/N 17256752 N35409Sandvik Randall L · Palmer, AKBuilt 1941 · S/N 5-660 N3540TAvcorp Holdings Inc · Jackson, MIBuilt 2001 · S/N 17281077 N35411Cherry Hill Aviation Inc · Freetown, INBuilt 1968 · S/N 17256755 N35415Irving Kyle P · Wasilla, AKS/N 5-666 N3541EClear Skies Aviation LLC · Longs, SCBuilt 1978 · S/N 17271578 N3541KGauvin Daniel G · Newport, VTBuilt 1967 · S/N 28-23616 N3541MPhillips Alan Roger · Anchorage, AKBuilt 1947 · S/N 12-2388 N3541PZang Peng · Mason, MIBuilt 1955 · S/N 22-3297 N35420Edwards David S · Colbert, WABuilt 1968 · S/N 17256759 N35421Gleason Franklin R · Darlington, SCFirst renewal noticeBuilt 1968 · S/N 17256760 N35422Hamilton Pamela P · Norman Park, GABuilt 1968 · S/N 17256761 N35423Curenton Rufus B · Elmore, ALBuilt 1968 · S/N 17256762 N35424Terkeurst William J IV · Gurley, ALBuilt 1941 · S/N 5-675 N35425Calloway Julius W III · Indianapolis, INBuilt 1968 · S/N 17256763 N3542KJames Anthony · Lexington, NCS/N 28-23617 N3542MRobertson Keith A · Wasilla, AKBuilt 1947 · S/N 12-2099 N35434Chalk 2 Inc · Apple Valley, CABuilt 1968 · S/N 17256768 N35441Boe Shay Lynn · Mesa, COBuilt 1968 · S/N 17256771 N35444Schmidt Richard E · Fort Myers, FLBuilt 1941 · S/N 6349 N35446Adelman Hiram · Bass Harbor, MES/N 17256773 N35449Whitlow Ray T · Shelbyville, KYBuilt 1968 · S/N 17256774 N3544BAvcorp Holdings Inc · Jackson, MIBuilt 2001 · S/N 17281071 N3544KKelso Ted M · Fort Worth, TXBuilt 1967 · S/N 28-23618 N3544LLabounty Dana G · Sumter, SCBuilt 1978 · S/N 0800 N3544PClark John W · New Philadelphia, OHBuilt 1955 · S/N 22-3300 N3544XKing Richard S · San Antonio, TXBuilt 1999 · S/N 2068 N35450Cole William A · San Francisco, CABuilt 1968 · S/N 17256775 N35452Shannon Todd J · Mitchell, SDBuilt 1941 · S/N 6357 N35454Norman Robert Alan · Zanesville, OHBuilt 1968 · S/N 17256778 N35456Wing Dock LLC · Miami, OKBuilt 1968 · S/N 17256779 N3545ARp Sky Ranch LLC · Lewes, DEBuilt 1953 · S/N 22-1819 N3545BDesert Aircraft Services LLC · Scottsdale, AZBuilt 2011 · S/N 23115 N3545DHudson Guy G · Chickaloon, AKS/N 27088 N3545KMil2atp Inc · Pikeville, NCBuilt 1967 · S/N 28-23619 N35461Registered aircraftBuilt 1968 · S/N 17256781 N35467Brown Wilson J · Statesville, NCBuilt 1968 · S/N 17256785

Back to AD 90-04-06 R1