Skip to content

Registered aircraft · 8,138

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

N2319TJensen Betty K · Ithaca, NYBuilt 1971 · S/N 28-7105212 N2323TTweeddale Thomas A · Denton, TXBuilt 1971 · S/N 28-7125606 N232WFSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1966 · S/N 28-21971 N2333RSightler Marshal · Taylors, SCBuilt 1969 · S/N 28-5491 N2334TGogoplex LLC · Wilmington, DEBuilt 1971 · S/N 28-7125637 N2336RPerera Nandana L · Logan, OHBuilt 1969 · S/N 28-5494 N233SPBuchwald Greg W · Grapevine, TXBuilt 1961 · S/N 28-223 N2341TSky King Aviation LLC · Kearney, MOBuilt 1971 · S/N 28-7225048 N2343RSkyhawk Aviation LLC · Rutherfordton, NCBuilt 1969 · S/N 28-5495 N2343TManire Christine D · Ruidoso, NMBuilt 1971 · S/N 28-7225049 N2346TBailey Benjamin J · Lincolnton, GABuilt 1971 · S/N 28-7225050 N2351BRegistered aircraftBuilt 1973 · S/N 28-7325535 N2360RLamarra Anthony A · Clarkston, MIBuilt 1969 · S/N 28-5496 N2361RVenture West LLC · Mesa, AZBuilt 1969 · S/N 28-5497 N2364TVintage Aero Club · Smoketown, PABuilt 1971 · S/N 28-7225055 N2371TThomas Jacob W · Loris, SCS/N 28-7225056 N2373TNeuharth Randall H · Norfolk, NEBuilt 1971 · S/N 28-7225003 N2374TFlying High Investments LLC DBA · Winnemucca, NVBuilt 1971 · S/N 28-7225017 N2376TStranberg Ray L · Bakersfield, CAS/N 28-7225057 N2378TKeiffer Taylor H · Atlanta, GABuilt 1971 · S/N 28-7225059 N237CSHorizon Flyers LLC · Kingsford, MIBuilt 1968 · S/N 28-24230 N2380TRegistered aircraftS/N 28-7225060 N2382TGethers Adolph B · Dothan, ALBuilt 1971 · S/N 28-7205031 N2385TSquawk 1200 LLC · Springboro, OHBuilt 1971 · S/N 28-7225064 N2386RLand Air & Sea LLC · Concord, NCBuilt 1970 · S/N 28-5602 N2386THub City Aviation Academy LLC · Lubbock, TXBuilt 1971 · S/N 28-7225065 N2390TKessler Derek D · Lexington, OKS/N 28-7225068 N2391TLotnicza LLC · Houston, TXBuilt 1971 · S/N 28-7225069 N2393TShool Board Of Marion County Florida · Ocala, FLBuilt 1971 · S/N 28-7225066 N2395TSingh Harsimran · Las Vegas, NVBuilt 1971 · S/N 28-7205049 N2397TSound Approach Aviation LLC · Seattle, WABuilt 1971 · S/N 28-7225070 N2399TThompson Nolan E · Houston, TXBuilt 1971 · S/N 28-7205052 N23JTWhitman Michael V · Guys Mills, PABuilt 1972 · S/N 28-7325192 N2400Ticknor Rodney J · Bridgewater, IABuilt 1967 · S/N 28-4586 N240MKFly254 LLC · Waco, TXS/N 28-26527 N2412RGagnon David D · New Market, ALS/N 28-5615 N2413TRing Michael E · Lake Village, INBuilt 1971 · S/N 28-7205053 N2418RMann Steven · High Springs, FLBuilt 1969 · S/N 28-5617 N2421RMerryman Todd K · Shickley, NEBuilt 1969 · S/N 28-5618 N2422YMarker Aviation LLC · Keller, TXBuilt 1966 · S/N 28-3171 N2423RAluminum Falcons Flying Club LLC · Bloomsburg, PABuilt 1969 · S/N 28-5619 N2424FPerformance Aviation Services LLC · Belmont, OHBuilt 1964 · S/N 28-2117 N2424VLuvsflying Flight Training LLC · Staten Island, NYBuilt 1972 · S/N 28-7225586 N2427RFalcon Flight Squadron Inc · Los Angeles, CABuilt 1969 · S/N 28-5620 N24342Loma Aviation LLC · San Diego, CABuilt 1973 · S/N 287305419 N24372Curns James R · New London, WIBuilt 1970 · S/N 28-5665 N2438RSpeed Hunter Aviation LLC · Franklin, OHBuilt 1969 · S/N 28-5622 N243XJLoiacono Vincent · Sunfield, MIBuilt 1965 · S/N 28-2095 N2447RGift Academy Inc · Vernon, TXBuilt 1969 · S/N 28-5623 N2448RRegistration Pending · Highland Lakes, NJRegistration pendingS/N 28-5624

Back to AD 96-10-01 R1