Skip to content

Registered aircraft · 72,010

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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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.

N5511QJohnston Evan · Yakima, WABuilt 1965 · S/N 2944 N55121Lifetime Adventures LLC · Bellevue, MIBuilt 1981 · S/N 17275114 N55124Stroud Stephen D · Independence, MOS/N 28-7325329 N55126Zing Aviation And Marine LLC · New Smyrna Beach, FLFirst renewal noticeBuilt 1981 · S/N 17275116 N55127Lands James M · Stoutsville, OHBuilt 1973 · S/N 28-7305314 N55129Bauer Roger · Saint Germain, WIBuilt 1973 · S/N 28-7305319 N5512CGayle William G · Harpersville, ALBuilt 2001 · S/N 18076C N5512FWestergaard Wayne B · Craig, NEBuilt 1968 · S/N 28-24854 N5512JWhitaker Robbie L · Brooklet, GABuilt 1968 · S/N 32-973 N5512URegistration Pending · Smiths Station, ALRegistration pendingBuilt 1969 · S/N 28-26223 N5512VCabaniss Tex P Jr · Cypress, TXBuilt 1977 · S/N 28-7725240 N5512WMoy Jack M · Los Angeles, CABuilt 1962 · S/N 28-600 N5512ZShadow Aviation Inc · Fairbanks, AKBuilt 1964 · S/N 18-7845 N55131Sansone Gary A · Fort Laramie, WYBuilt 1973 · S/N 28R-7335184 N55134Xin Han Aviation LLC · Atwater, CABuilt 1973 · S/N 34-7350177 N55135Air Ventures Flying School LLC · Smithfield, RIBuilt 1973 · S/N 28-7325331 N55136Alberio Angela E · Bloomington, MNBuilt 1973 · S/N 28-7325332 N55139Hanson Mark A · Snelling, CABuilt 1973 · S/N 28-7305320 N5513NBig Blue Aviation LLC · Pinehurst, NCBuilt 1980 · S/N 18267764 N5513UShi Yi · Walnut, CABuilt 1969 · S/N 28-26225 N5513WJohnson Thomas D · Pilot Mountain, NCBuilt 1962 · S/N 28-601 N55140Di Giorgio Thomas J Jr · Lopez Island, WABuilt 1973 · S/N 28-7305321 N55144Bell Air LLC · Las Cruces, NMBuilt 1981 · S/N 17275118 N55146Sky High Aviation LLC · Gonzales, LABuilt 1981 · S/N 17275119 N55148Lierle Sidney D · Clearlake, CABuilt 1973 · S/N 28-7325333 N55149County 17 Aviators LLC · Gillette, WYS/N 28-7325334 N5514FWingrove Rodney W · Vincent, OHBuilt 1968 · S/N 28-24856 N5514MPruitt Buster Jr · Shelbyville, TNBuilt 1967 · S/N 113 N5514PCohran Enterprise LLC · Pineville, LABuilt 1958 · S/N 24-577 N5514QKurtz Hans E · Clewiston, FLBuilt 1965 · S/N 610 N5514UCheckers Investments Inc · Edmond, OKBuilt 1969 · S/N 28-26226 N55150Alexander Dennis K · Gallatin, TNBuilt 1973 · S/N 28-7305322 N55151Learn 2 Fly LLC · Cantonment, FLBuilt 1973 · S/N 28-7415001 N55154Kanpahem Aviation LLC · Hawkins, TXBuilt 1973 · S/N 28R-7335187 N55159Rasmussen Paul H · Mitchell, SDBuilt 1973 · S/N 32-7340103 N5515LDoody Michael C · Knoxville, TNBuilt 2003 · S/N 18060C N5515MBarringer William R · Benbrook, TXBuilt 1967 · S/N 140 N5515SGotay Ricardo M · Watertown, CTBuilt 2003 · S/N 33004C N5515VMt Aircraft LLC · Port Orange, FLS/N 30023C N55160Davis Joseph S · Andalusia, ALBuilt 1981 · S/N 17275123 N55163Jackson Donald W · Carthage, MSBuilt 1973 · S/N 28-7325335 N55166Volando LLC · Columbia, MOBuilt 1973 · S/N 28-7325338 N55167Flyboys Nevada LLC · Henderson, NVBuilt 1973 · S/N 28-7305325 N55169Jin Jin Aviation LLC · Anchorage, AKBuilt 1981 · S/N 17275126 N5516FMoore Marcus · Auburn, ALS/N 28-24858 N5516JRobarge Andrew Michael · Crown Point, INBuilt 1967 · S/N 32-925 N5516SAtc Trucking Inc · Miami, FLBuilt 2003 · S/N 28016C N5516UHicks David A · Beaver Dam, WIBuilt 1969 · S/N 28-26228 N55173Dareing Chon · San Antonio, TXBuilt 1973 · S/N 28-7305327 N55176Hall Davis · Mobile, ALBuilt 1973 · S/N 28R-7335189

Back to AD 87-10-06 R1