Skip to content

Registered aircraft · 26,231

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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.

N4204EKutsenko Tatyana Executrix Personal Representative · Sammamish, WAS/N 11CC-100 N4204FStephani Timothy M · White Lake, WIS/N 46104 N4204LMarquis Kim R · Poplar Bluff, MOBuilt 1966 · S/N 17254273 N4205FMunoz Randy · Aledo, TXBuilt 1958 · S/N 46105 N4205LKay Bennie L · Brigham City, UTBuilt 1966 · S/N 17254274 N4205UCentral California Soaring Association Inc · Avenal, CABuilt 1963 · S/N 15060205 N42071Petschauer Erik K · Honesdale, PABuilt 1945 · S/N 14298 N4207LGlaude Jason T · Scarborough, MEBuilt 1966 · S/N 17254276 N4207VTeufel Gregory W · Lake Stevens, WABuilt 1948 · S/N 18563 N42080Leaders Bob O · Clear Lake, MNS/N 14307 N42083Olufsen Jane E · Lakeway, TXBuilt 1945 · S/N 14310 N4208LHowell Jerry C · Deatsville, ALBuilt 1966 · S/N 17254277 N4209NVan Dyke Stewart D · Carmel, INBuilt 1947 · S/N 13680 N420WWFlying Colors Airparts Inc · Leesburg, FLS/N 15069243 N4210FOsterhouse Daniel E · Mattawan, MIBuilt 1958 · S/N 46110 N4210VHolman Ricardo · Pleasant Hill, ORBuilt 1948 · S/N 18566 N4212NGrieff Jorden A · Hollywood, FLFirst renewal noticeS/N 13683 N4213LBuenrostro Paul · Burney, CAS/N 17254282 N4213UDemuri Daniel J · Woods Cross, UTS/N 15060213 N42146Adams Thomas R · Anchorage, AKBuilt 1945 · S/N 14375 N4214EAndrew Louis J Jr · Milwaukee, WIS/N 11CC-106 N4214NNininger Beverly S II · Vinton, VABuilt 1947 · S/N 13685 N4214VGat Air & Ground LLC · Norwich, NYBuilt 1948 · S/N 18570 N4215FBoss Brothers Aviation LLC · Buffalo, MOBuilt 1958 · S/N 46115 N4215UMaynard Paul E · Grand Junction, COBuilt 1964 · S/N 15060215 N4215VTriplett Taran R · Cheyenne, WYBuilt 1948 · S/N 18571 N4216LN4216l LLC · Kapolei, HIBuilt 1966 · S/N 17254285 N4216UNaeve James M · Renton, WABuilt 1963 · S/N 15060216 N42179Simonson Larry A · Dalton, MNS/N 14421 N4218FPerry Michael C · Edgewater, FLS/N 46118 N4218LWengs Enterprises Inc · Tustin, CABuilt 1966 · S/N 17254287 N42196Simonson Seth W · Sunman, INS/N 14438 N42207Sparling George B · Grand Prairie, TXBuilt 1945 · S/N 14453 N4220FLeubner Karl T · Marietta, NYS/N 46120 N4220LDelordzia Mark · Columbia, NJBuilt 1966 · S/N 17254289 N4220NOneill Mark B · Pinckney, MIS/N 13691 N4220VMckinley Jason · Coulterville, ILBuilt 1948 · S/N 18576 N4221LSchram Ted K · Mukwonago, WIBuilt 1966 · S/N 17254290 N4221VBashore Barry A · Pleasant Hill, OHBuilt 1948 · S/N 18577 N4222EDerendinger Kevin B · Cole Camp, MOBuilt 1947 · S/N 11CC-112 N4222FBelford Zackery U · Elizabethtown, ILBuilt 1958 · S/N 46122 N4222LRtd Aviation LLC · Hillsborough, NJS/N 17254291 N42239Adkins Clint R · Corvallis, MTBuilt 1945 · S/N 14489 N4223LWolinski David T · Algonquin, ILBuilt 1966 · S/N 17254292 N4223NLinden Michael A · Rockford, ILBuilt 1947 · S/N 13694 N4223VMcdermotts Letsfly LLC · Somerton, AZBuilt 1948 · S/N 18579 N4224VDouglas Phillip A · Fredericktown, OHS/N 18580 N42253Tapley Jeffery L · Glen Saint Mary, FLBuilt 1945 · S/N 14503 N42259Massie Sean A · Wooster, OHS/N 14509 N4225L100straight LLC · San Angelo, TXBuilt 1966 · S/N 17254294

Back to AD 94-05-05 R1