Skip to content

Registered aircraft · 4,242

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:89-24-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:89-24-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:89-24-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:89-24-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:89-24-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:89-24-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.

N59EMFletcher Marvin L · Fargo, NDBuilt 1984 · S/N 46-8508022 N59KJSpike LLC · Cheyenne, WYBuilt 1993 · S/N EA-549 N5AMTexas La Flyers LLC · West Monroe, LAFirst renewal noticeBuilt 1979 · S/N 414A0441 N5BPTippettsolutions LLC · Fort Mill, SCBuilt 1980 · S/N TJ-315 N5CGSamair LLC · Blackshear, GABuilt 1979 · S/N 340A0751 N5CNLewis Gentry Holdings LLC · Orlando, FLBuilt 1978 · S/N 414A0073 N5ERMill Direct Textiles LLC · Rollinsford, NHBuilt 1982 · S/N T30300137 N5JKLizard Two LLC · Wilmington, DEBuilt 1981 · S/N TJ-295 N5NMNelson Jeffrey S · Darby, MTBuilt 1978 · S/N 414A0042 N5PAFinal Design Group LLC · Hurricane, UTBuilt 1981 · S/N EA-251 N5ZTAllen Airplane LLC · Durango, COBuilt 1973 · S/N 414-0477 N60018Moreno & Nelson Construction Corp · Walla Walla, WABuilt 1973 · S/N U20602002 N6006NFraser Shane · San Marcos, TXBuilt 1978 · S/N 21062875 N600HCCessna 414a LLC · Portland, ORBuilt 1978 · S/N 414A0025 N600PAHeaven'S Landing Realty Inc · Clayton, GABuilt 1980 · S/N TJ-250 N600THN600th LLC · Fredericksburg, VABuilt 1981 · S/N 414A0668 N600WLMoore Stan D · Amarillo, TXBuilt 1979 · S/N P21000409 N6012SWhaley Carl S · Shelby, NCS/N TJ-15 N6013BFrost Sean D · Lovell, WYS/N 21062664 N6017SEisma Thomas Eugene · Golden, COBuilt 1975 · S/N TJ-17 N6018SJohnson Thomas G · New Port Richey, FLS/N TJ-19 N6020NWatts Carl · Thousand Oaks, CABuilt 1978 · S/N 21062888 N6024KNabarrette Angel · Odessa, TXBuilt 1979 · S/N TJ-187 N6024SAdams Erik S · Bozeman, MTBuilt 1975 · S/N TJ-16 N6028NBernhard Mark J · Alamo, CABuilt 1978 · S/N 21062896 N60306Ibikunle Christopher S · Grayson, GABuilt 1979 · S/N TJ-195 N6032NHqgt210 LLC · Hugoton, KSBuilt 1978 · S/N 21062900 N6032VLawler Craig R · Milton, PABuilt 1979 · S/N D-10227 N6032XWinged Chariot LLC · Cincinnati, OHBuilt 1979 · S/N TJ-197 N6036NMorales Juan · Addison, TXBuilt 1978 · S/N 21062904 N6037BDel Mar Aviation Inc · Wilmington, DEBuilt 1978 · S/N 21062667 N6037GMojo Travel LLC · Wellington, COBuilt 1979 · S/N TK-96 N6038BHaarmeyer Air LLC · Lovington, NMBuilt 1978 · S/N 21062668 N6039TLindsey Kenneth H · Kalispell, MTBuilt 1979 · S/N TK-97 N603ETSanborn Map Co · Colorado Springs, COBuilt 1973 · S/N U20602230 N6044SPinewood Properties LLC · Hayward, WIBuilt 1976 · S/N TJ-42 N6047SNeihouser Brad · Francesville, INBuilt 1976 · S/N TJ-37 N6048NAero-Mach Labs Inc · Wichita, KSBuilt 1978 · S/N 21062916 N6057SRamelow Noyan · Seabrook, TXBuilt 1976 · S/N TJ-45 N6059SGallardo Jorge Luis Marquez · El Mirage, AZS/N TJ-49 N60636Allard Michael L · Penrose, COS/N 21060596 N6069PAirborne Helicopters LLC · Hendrum, MNBuilt 1978 · S/N P21000136 N606BCBell Camp Inc · Lubbock, TXFirst renewal noticeBuilt 1980 · S/N EA-72 N606PPAndriopulos Salguero Inc · Hialeah, FLS/N 414-0416 N606REPebblebrook Aviation LLC · Ellinwood, KSBuilt 1982 · S/N TJ-430 N607GSGaines Robert G · Howell, MIBuilt 1982 · S/N TK-147 N607JDJd 707 Air LLC · Edgerton, OHBuilt 1978 · S/N 414A0071 N6083BListo Aviation LLC · Lewes, DEFirst renewal noticeBuilt 1978 · S/N 21062677 N6084BCenturion Aviation Ltd · Salina, KSBuilt 1978 · S/N 21062678 N6088PSide Deck Event Management LLC · Lexington, SCBuilt 1978 · S/N P21000141

Back to AD 89-24-01 R1