Skip to content

Registered aircraft · 8,921

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:85-02-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:85-02-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:85-02-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:85-02-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:85-02-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:85-02-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.

N2126XCandace A Learned Enterprises Inc · Long Beach, CABuilt 1979 · S/N 44-7995273 N2127DMetro Aircraft Co · Bloomington, MNBuilt 1978 · S/N 447995131 N2128ANull Clifford M · Punxsutawney, PABuilt 1952 · S/N 22-570 N2128XWnc Aviation LLC · Arden, NCBuilt 1979 · S/N 44-7995276 N212CKSkymates Inc · Grand Prairie, TXBuilt 1979 · S/N 44-7995294 N212GPWibel Enterprises Inc · Crossville, TNS/N 24-3327 N212RGGillum Reef · Clint, TXBuilt 1962 · S/N 24-3123 N21318Raw Racing Inc · Puyallup, WABuilt 1978 · S/N 44-7995046 N2138GFlorida Aviation Career Training Inc · St Augustine, FLBuilt 1979 · S/N 44-7995191 N213CBSkymates Inc · Wilmington, DEBuilt 2002 · S/N 4496147 N2140ALloyd Davis Inc · Brackettville, TXBuilt 1952 · S/N 22-572 N2141PElliott David E · Peyton, COBuilt 1956 · S/N 23-734 N21438Texas State Technical College · Waco, TXBuilt 1979 · S/N 44-7995051 N2143AUniversal Aviators Academy Inc · El Monte, CABuilt 1978 · S/N 44-7995085 N2144AWhite James O · Bim, WVBuilt 1952 · S/N 22-582 N2147AHosmer Richard Alan · Cedartown, GABuilt 1952 · S/N 22-578 N2148FRegistration Pending · Wilmington, DERegistration pendingBuilt 1978 · S/N 44-7995157 N214EDWoods Johnny I · Hendersonville, TNBuilt 1980 · S/N 44-8195007 N214HSDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 1975 · S/N 27-7654014 N214JNFox-1 Drafting & Design Inc · Eagan, MNBuilt 1966 · S/N 30-1130 N214LMHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1978 · S/N 44-7995053 N21500Cal Aggie Flying Farmers Inc · Davis, CABuilt 1978 · S/N 44-7995055 N2150PWoodard Mark A · Hookstown, PABuilt 1956 · S/N 23-752 N2156BTassmanian Aircraft LLC · Middletown, DEBuilt 1978 · S/N 44-7995100 N215FWAtp Aircraft 2 LLC · Wilmington, DES/N 447995056 N2162KApm Leasing LLC · Casper, WYBuilt 1978 · S/N 44-7995198 N2162PLark Aircraft Leasing · Port Townsend, WABuilt 1956 · S/N 23-764 N2163ASharp Roscoe A · Deer Park, WAS/N 20-891 N2163FSkywarrior Flight Training Inc · Pensacola, FLBuilt 1978 · S/N 44-7995167 N2163PCarroll Bodo W · Franklin, OHBuilt 1956 · S/N 23-765 N2164AStejskal Frank P · Carmel, INBuilt 1952 · S/N 22-583 N2165ASistrunk Mark W · Ragley, LABuilt 1952 · S/N 22-586 N2166AKnutson Wayne R · Tioga, NDBuilt 1952 · S/N 20-892 N2168PSmith Kevin L · Peachtree City, GAS/N 23-773 N216FWAtp Aircraft 2 LLC · Wilmington, DEBuilt 1979 · S/N 447995181 N2170NCottle Dennis J · Bainbridge Island, WABuilt 1979 · S/N 44-7995224 N2171APfrender Harold R · Orlando, FLBuilt 1952 · S/N 22-590 N2172AMarx David V · Sauk City, WIS/N 22-589 N2172MPacker Bruce P Trustee · Tempe, AZBuilt 1963 · S/N 24-3305 N2172PRiggin Flight Service Inc · Madison, SDBuilt 1956 · S/N 23-778 N2173AVose Dylan · Fort Lauderdale, FLBuilt 1952 · S/N 22-593 N2173SSunrise Aviation Inc · Ormond Beach, FLBuilt 1979 · S/N 44-7995245 N2177ADison Eric R · Battle Lake, MNBuilt 1952 · S/N 22-594 N2177PMidwest Environmental Products Inc · Wichita, KSBuilt 1956 · S/N 23-783 N2179ASharon Carl G · Brookshire, TXBuilt 1952 · S/N 22-597 N217HCSwartzendruber Brett E · Hesston, KSBuilt 1963 · S/N 30-166 N2180AStout Billy V · Hooker, OKFirst renewal noticeBuilt 1952 · S/N 22-598 N2182AMclaughlin Mark S · Cold Brook, NYBuilt 1952 · S/N 22-600 N2186AConant Stephen A · Nyssa, ORBuilt 1952 · S/N 20-894 N218KKSkymates Inc · Wilmington, DEBuilt 2002 · S/N 4496153

Back to AD 85-02-05 R1