Skip to content

Registered aircraft · 26,232

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.

N681RLWeatherby Thomas M · Rcho Sta Marg, CAS/N 28633 N6820GJensen Eric Gunnar · Ogden Dunes, INBuilt 1970 · S/N 15072320 N6820HGreenfield Samuel B · Firth, NEBuilt 1946 · S/N 20036 N6821AArmiger Scott Linwood · Holly Springs, NCBuilt 1956 · S/N 28921 N6821EPriest Justin E · Arlington, WABuilt 1959 · S/N 56321 N6821GMueller Carla I · Lexington, SCS/N 15072321 N6821XTudorani Vincenzo C · Las Vegas, NVS/N 47721 N6822AStewart Brock Allen · Bartlett, TNBuilt 1956 · S/N 28922 N6822GKnot Enough Airspeed LLC · Oshkosh, WIBuilt 1970 · S/N 15072322 N6823AWilliams Daniel H · Fort Mcdowell, AZBuilt 1956 · S/N 28923 N6823GLopes Gaston A · Dallas, TXBuilt 1970 · S/N 15072323 N6823XTipton Wendell D · Anchorage, AKBuilt 1960 · S/N 47723 N6824AChristenson Robert E · Anacortes, WABuilt 1956 · S/N 28924 N6824DRoss Kevin C · Edson, KSBuilt 1964 · S/N 1 N6825ABarker Jason · Hampton Falls, NHBuilt 1956 · S/N 28925 N6825FKieffer Jason M · Omaha, NEBuilt 1966 · S/N 15063425 N6825GRhodes Bruce A · Santa Cruz, CABuilt 1970 · S/N 15072325 N6826ERudolphi Ben M · Valdosta, GAS/N 56326 N6826FJeppesen Thomas L · Stanton, MIBuilt 1966 · S/N 15063426 N6826GStar Voyages LLC · Kissimmee, FLS/N 15072326 N6827GBrooks Jeffrey C · Bridgeton, NJBuilt 1970 · S/N 15072327 N6827XCalderon Daniel C · Castro Valley, CABuilt 1960 · S/N 47727 N6828ESheppard Walter S · Troy, IDBuilt 1959 · S/N 56328 N6828HStick & Rag Flying Club · Clarinda, IABuilt 1946 · S/N 20047 N6829ABaker Elbert W · Beckley, WVBuilt 1956 · S/N 28929 N6829ELay Steven K · New Vienna, OHBuilt 1959 · S/N 56329 N6829XZeegers Jozef · Bellingham, WABuilt 1960 · S/N 47729 N682ADDuncan Brian · Indianapolis, INBuilt 1971 · S/N 15072493 N6830ALange Cole K · Oglala, SDBuilt 1956 · S/N 28930 N6831ASale Reported · Pullman, WASale reportedS/N 28931 N6832EStuebner David M · Delanson, NYBuilt 1959 · S/N 56332 N6832GAeronautical Technical Service Inc · Collierville, TNS/N 15072332 N6832XOwens Philip A · Maryville, TNBuilt 1960 · S/N 47732 N6833AChapter 163 Flying Club · Las Vegas, NVBuilt 1956 · S/N 28933 N6834FLecompte Kevin J · Lancaster, MABuilt 1966 · S/N 15063434 N6834GRoberts Edwin G · Lake Wales, FLBuilt 1970 · S/N 15072334 N6835ABaratka Darin W · Phillips, WIBuilt 1956 · S/N 28935 N6836ARiner Mark G · Bartlesville, OKBuilt 1956 · S/N 28936 N6836FFoley Anthony · Savannah, GABuilt 1966 · S/N 15063436 N6836GRegistration Pending · Highland, UTRegistration pendingBuilt 1970 · S/N 15072336 N6836XNelson John D · Sonora, CABuilt 1960 · S/N 47736 N6837ANorth Nathan A · Damascus, MDBuilt 1956 · S/N 28937 N6837FSkyberjet LLC · Allen, TXBuilt 1966 · S/N 15063437 N6838EBognar Jeffrey L · Kinnelon, NJBuilt 1959 · S/N 56338 N6839XCripe Rodney J · Middlebury, INBuilt 1960 · S/N 47739 N683HDFord Dwight M · Gig Harbor, WAS/N 17250499 N6840AMcnaught Scott S · Winlock, WABuilt 1956 · S/N 28940 N6840FBushre David · Janesville, WIBuilt 1966 · S/N 15063440 N6840GMiller Robert L · Tecumseh, MIBuilt 1970 · S/N 15072340 N6840XDesertshot Inc · El Paso, TXBuilt 1960 · S/N 47740

Back to AD 94-05-05 R1