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.

N2449EWikette Mathias · West Chester, OHBuilt 1970 · S/N 28-26801 N244DRG H Enterprises Inc · Baton Rouge, LABuilt 1972 · S/N 28-7305018 N244SDPerazzo Enterprises Inc · Brookeland, TXS/N 28-7125536 N2451ROracle Aviation LLC · Omaha, NEBuilt 1970 · S/N 28-5754 N2453RCendejas Christian · Montclair, CABuilt 1969 · S/N 28-5626 N2454TSummit Skyhawk LLC · Pleasant Hill, ORBuilt 1971 · S/N 28-7205054 N245QWhitaker William D · Mt Pleasant, TXBuilt 1968 · S/N 28-24382 N2460RScilex Richard D · Hixson, TNBuilt 1969 · S/N 28-5627 N2462RTrade Winds Aviation Holdings LLC · Lewes, DEBuilt 1969 · S/N 28-5628 N2465RDarrow Brett · Minerva, NYS/N 28-5629 N2468TMackie Robbie L · Murfreesboro, TNBuilt 1971 · S/N 28-7225074 N2477T7 Shooter Ranch LLC · Aledo, TXBuilt 1971 · S/N 28-7205055 N2478T5b Aviation LLC · Duncan, OKBuilt 1971 · S/N 28-7205059 N2481TWidell Randall Ross · Wilsonville, ORBuilt 1971 · S/N 28-7205058 N2485RGriffith Kyle R · Talihina, OKBuilt 1969 · S/N 28-5633 N248BFotheringham Jack · Palmer, AKS/N 28-7505135 N2491TLichtman Bruce A · Stafford, VABuilt 1971 · S/N 28-7225078 N2492TOmni Aviation LLC · Pickerington, OHBuilt 1971 · S/N 28-7205060 N2495TAvia Flight Academy LLC · Stratford, CTBuilt 1971 · S/N 28-7205061 N2497RMarkley John T · Center Harbor, NHBuilt 1969 · S/N 28-5636 N2499QLand Phillip R · Hartford, WIBuilt 1977 · S/N 28-7725197 N24APMartinelli John P · Cumberland, RIBuilt 1973 · S/N 28-7305199 N24FLHill Steven D · Carroll, IABuilt 1964 · S/N 28-1790 N24JSSpillman Joe H · Marble Falls, TXBuilt 1967 · S/N 28-3851 N24NAForcey Marcia L · Westville, INBuilt 1967 · S/N 28-4018 N2500UFrisbie Anthony G · Dallas, TXBuilt 1964 · S/N 28-1873 N2501RNelson Curtis J · Altoona, IABuilt 1969 · S/N 28-5637 N2505RTcheutchua Romeo J · Olathe, KSBuilt 1969 · S/N 28-5638 N2509RStovall Shane R · Salado, TXBuilt 1969 · S/N 28-5639 N2517RWaterfront Developers Inc · Hickory, NCBuilt 1969 · S/N 28-5640 N2521RSok Gregory J · Wallingford, CTBuilt 1969 · S/N 28-5641 N252ECClear Sky Ag Services LLC · Arapahoe, COBuilt 1969 · S/N 28-25277 N252GBrewster King Smith Jr · Gilbert, AZBuilt 1969 · S/N 28-26191 N2531RMaierhoffer Henry F Jr · Sylvania, GAS/N 28-5642 N253SWBatts David · Lyons, COBuilt 1965 · S/N 28-2328 N253WMLambert Timothy Allen Jr · Burleson, TXBuilt 1964 · S/N 28-2026 N2546QAishvaryam LLC DBA · Lancaster, TXS/N 28-7725199 N2547QLawrence Thomas C · Memphis, TNBuilt 1977 · S/N 28-7725200 N25511Gleason Randy H · Redding, CABuilt 1969 · S/N 28-25718 N2555BHadden Fleming Cindy L · San Antonio, TXS/N 28-25678 N2566QCarothers Rayburn T · Brevard, NCBuilt 1977 · S/N 28-7725201 N2568RCraven James J · Pensacola, FLBuilt 1969 · S/N 28-5649 N2580RFlight Club Academy LLC · Palmetto Bay, FLBuilt 1969 · S/N 28-5650 N2593RWeatherly Lloyd W · Wittmann, AZS/N 28-5654 N2598RRiff Raff Air LLC · Isle La Motte, VTBuilt 1969 · S/N 28-5655 N2599RNeo Aero LLC · Youngstown, OHBuilt 1969 · S/N 28-5656 N25DSteves Landavator Service LLC · Oley, PABuilt 1964 · S/N 28-1919 N25PLWaterboy Aviation LLC · Richlandtown, PABuilt 1967 · S/N 28-23540 N261FCVu Ai · Aiea, HIBuilt 1968 · S/N 28-24697 N2621QBrown Russell C · Howey, FLBuilt 1977 · S/N 28-7725202

Back to AD 96-10-01 R1