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.

N2924FReese Howard Aviation LLC · Anderson, SCBuilt 1966 · S/N 18257024 N2924YLilcad Diversified LLC · Holly Pond, ALBuilt 1962 · S/N 18253924 N2925AVan Der Molen Baron J · Readstown, WIBuilt 1953 · S/N 30125 N2925CElla Butte Farming Co · Ione, ORBuilt 1954 · S/N 30825 N2925FRegistered aircraftAssigned, pending cancellationS/N 18257025 N2925YTrinity Air LLC · Lewes, DES/N 18253925 N2926YViramontes Gilbert A · Temple City, CABuilt 1962 · S/N 18253926 N29278Pancho Moreno Y La Flaca LLC · Camuy, PRBuilt 1973 · S/N 21059852 N2927YReynolds Nathan W Jr · Piedmont, SCBuilt 1962 · S/N 18253927 N29289Disarro Wayne · Wasilla, AKBuilt 1968 · S/N U206-1211 N2928YDiamond X LLC · Elko, NVBuilt 1962 · S/N 18253928 N29292Skytime Aviation LLC · Tulsa, OKBuilt 1968 · S/N U206-1212 N29299Svetic Russell T · Redondo Beach, CABuilt 1968 · S/N U206-1216 N2929CSinnott Simonis Lyle · Girdwood, AKFirst renewal noticeBuilt 1954 · S/N 30829 N2929FSmith Lane R · Lewistown, MTBuilt 1966 · S/N 18257029 N292CBPelton Project · Keizer, ORBuilt 1975 · S/N 18264306 N292CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281992 N292CSStature Aviation LLC · Addison, TXBuilt 2025 · S/N 18283292 N292MAHot Tails LLC · Richmond, MOBuilt 1998 · S/N 18280174 N292PZMalone Patrick A · Tuscumbia, ALS/N 185-0375 N2930FWrucke Scott · Horicon, WIBuilt 1966 · S/N 18257030 N2931AStrategic Aircraft Management LLC · Fairbanks, AKBuilt 1953 · S/N 30131 N2931YWiesner Norman P Trustee · Silverton, ORBuilt 1962 · S/N 18253931 N2932AHenderson Steven A · Idaho Falls, IDBuilt 1953 · S/N 30132 N2933CLawson Matt E · Gobles, MIS/N 30833 N2933FLevinsohn Reuben D · East Lansing, MIBuilt 1966 · S/N 18257033 N2934ADixon Devin M · Las Vegas, NVBuilt 1953 · S/N 30134 N2934FH & S Aviation LLC · Roseville, MNBuilt 1966 · S/N 18257034 N2934YOwens John A · Granville, OHBuilt 1962 · S/N 18253934 N29359Cervantes Jose DBA · San Diego, CABuilt 1973 · S/N 21059858 N2935CSuez Jose F · Tracy, CABuilt 1954 · S/N 30835 N2935FPeirce Brenden D · Eatonville, WABuilt 1966 · S/N 18257035 N2936CSale Reported · Stoughton, WISale reportedBuilt 1954 · S/N 30836 N2936EHansen Mark A Trustee · Long Beach, CABuilt 1975 · S/N 18052562 N2937YSkylane Inc · Moose Lake, MNBuilt 1962 · S/N 18253937 N2938AKoons John D · Waterville, MES/N 30138 N2938CKeller Dylan M · Meridian, IDBuilt 1954 · S/N 30838 N2938YFoster Amy L DBA · Jarrell, TXBuilt 1962 · S/N 18253938 N2939FGeorges Aerial Spraying Service Inc · Sutton, NEBuilt 1966 · S/N 18257039 N2939YDanzy Michael R · Oakdale, LABuilt 1962 · S/N 18253939 N293CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281993 N293RCCharlie Papa Aviation LLC · Mayaguez, PRBuilt 2006 · S/N 20608281 N2940ABarnett David E Trustee · Anchorage, AKBuilt 1953 · S/N 30140 N2940FHarry Daye Aviation Services LLC · Surprise, AZBuilt 1966 · S/N 18257040 N2940KRegistered aircraftBuilt 1980 · S/N 18053136 N2940YDi Giorgio Omar · Santa Fe, NMBuilt 1962 · S/N 18253940 N2942FSdc Aviation LLC · Fort Smith, ARBuilt 1966 · S/N 18257042 N2943AGraham Jason J · Anchorage, AKS/N 30143 N2943CBaas Brian · Cambridge, MNBuilt 1954 · S/N 30843 N2944AWalker Travis J · Wasilla, AKBuilt 1953 · S/N 30144

Back to AD 84-10-01 R1