Skip to content

Registered aircraft · 20,483

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

N2624GVietnam Helicopters · Concord, CABuilt 1959 · S/N 51924 N2624QKalarney Kerry T · Olathe, COBuilt 1966 · S/N 18257824 N2624XBritton Daniel W · Fairbanks, AKBuilt 1965 · S/N P206-0124 N2624YWarner James R · Van Alstyne, TXBuilt 1962 · S/N 18051124 N2625QSutton Aircraft Salvage LLC · Palmer, AKBuilt 1966 · S/N 18257825 N26264Edb Air Inc · Wilsonville, ORBuilt 1998 · S/N 18280265 N2626FJohnson James E · Stevensville, MTS/N 18256726 N2626KUpwind Floats LLC · Seattle, WABuilt 1979 · S/N 18053019 N2626QTomasini William M · Boring, ORBuilt 1966 · S/N 18257826 N2626R2626r LLC · Tucson, AZBuilt 1967 · S/N 18258326 N2627CC And T Aviation LLC · Shreveport, LABuilt 1978 · S/N R18200180 N2627FUlrich Robert W DBA · Twisp, WABuilt 1965 · S/N 18256727 N2627RTaylor John B · Norwich, OHBuilt 1967 · S/N 18258327 N2628FPlata Darryl · Arlington, WABuilt 1965 · S/N 18256728 N2628QSannikova Olga · Sherman Oaks, CAS/N 18257828 N2629FFodness Jan N · Sioux Falls, SDBuilt 1965 · S/N 18256729 N2629QStallings Floyd P · Vine Grove, KYBuilt 1967 · S/N 18257829 N262AFState Of Louisiana · Baton Rouge, LABuilt 2003 · S/N 18281187 N262ALDale County Sheriffs Office · Ozark, ALBuilt 1981 · S/N R18201836 N262CACompass Aviation Inc · Shelby, NCBuilt 1981 · S/N U20606094 N262CLGiga Energy Inc · Buna, TXBuilt 2004 · S/N 18281497 N262CPCivil Air Patrol · Maxwell Afb, ALBuilt 2017 · S/N 18283017 N262DQIschi Phillip · Soldotna, AKBuilt 1978 · S/N U20604479 N262GSMinor Michael D · Grove City, PAS/N 18265183 N262MTBurns Mark R · Streetsboro, OHBuilt 2016 · S/N 18282449 N2630GMarvil Sean · El Prado, NMS/N 51930 N2630QParrington Robert · Rifle, COS/N 18257830 N2630RBurdine Kenneth L · Newland, NCS/N 18258330 N2630XBbjc Adventures LLC · Jackson, WIBuilt 1965 · S/N P206-0130 N2631CAndrews John M · Titusville, FLBuilt 1978 · S/N R18200183 N2631FShepherd Thomas A · Montgomery, NYFirst renewal noticeBuilt 1965 · S/N 18256731 N2631GMac Neil David M · Clarkston, WABuilt 1959 · S/N 51931 N2631QManning Brian A · Malvern, IABuilt 1966 · S/N 18257831 N2632CSheldon Benjamin Lloyd · Duck Creek Village, UTBuilt 1978 · S/N R18200184 N2632FOn Final Holdings LLC · West Olive, MIBuilt 1965 · S/N 18256732 N2632GHuey James M · Fulton, MOFirst renewal noticeBuilt 1959 · S/N 51932 N2633CWalusz Bernice J · Linden, NJS/N R18200185 N2633FYork Greg · Blanco, TXBuilt 1965 · S/N 18256733 N2633RDevries Mark R · Eagle River, AKBuilt 1967 · S/N 18258333 N2634FCockerham Milton D · Gooding, IDBuilt 1965 · S/N 18256734 N2635BGrimes Jeremy M · Wasilla, AKBuilt 1959 · S/N 50390 N2635CMason Gregory J · Rice Lake, WIBuilt 1978 · S/N R18200186 N2635GStockton Finance Inc · New Braunfels, TXBuilt 1959 · S/N 51935 N2635KVerdi Stephen · Newtown, PABuilt 1978 · S/N 18053020 N2635RJong Hoon Cho · Rch Palos Vrd, CABuilt 1967 · S/N 18258335 N2636CSexton David Lee · Barnesville, GABuilt 1978 · S/N R18200187 N2636FCernilia James J · Newport Beach, CABuilt 1965 · S/N 18256736 N2636GHousken George E · Gardnerville, NVFirst renewal noticeBuilt 1959 · S/N 51936 N2637CSafety In Motion Flight Center Inc · Puyallup, WABuilt 1978 · S/N R18200188 N2637FMccrum James M · Seattle, WABuilt 1965 · S/N 18256737

Back to AD 84-10-01 R1