AD 77-13-21

Registered aircraft · 3,193

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
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:77-13-21')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:77-13-21')
  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.

N7249PDavis Scott · Bingham, NEBuilt 1960 · S/N 24-2425N7249YCt Capital LLC · Austin, TXS/N 30-274N724BMJensen William B Jr · Huntington, NYBuilt 1968 · S/N 24-4802N7250PTrayer Kevin B Trustee · Haslet, TXBuilt 1961 · S/N 24-2426N7252PSchaefer Hugh W · Merrick, NYBuilt 1961 · S/N 24-2428N7252YGuyer James · Billings, MTBuilt 1964 · S/N 30-277N7253YJednacz Scott T · Bixby, OKFirst renewal noticeBuilt 1964 · S/N 30-278N7254YSpldkd LLC · New Richmond, WIBuilt 1964 · S/N 30-280N7255PKubik Rodrick D · Waukee, IAFirst renewal noticeS/N 24-2431N7257YRice Clark D · Anaconda, MTFirst renewal noticeBuilt 1964 · S/N 30-290N7258YJprg Aviation Inc · Orlando, FLBuilt 1964 · S/N 30-291N7260PPotts Leah Marie · Roanoke, VABuilt 1961 · S/N 24-2436N7260YDeuce Aire LLC · Middletown, DEBuilt 1964 · S/N 30-294N7261YKocak Robert G Jr · Peoria, AZBuilt 1964 · S/N 30-295N7262PParker Dennis Scott · Lubbock, TXBuilt 1961 · S/N 24-2438N7263YRag Wings And Radials Aircraft Leasing LLC · Georgetown, DEBuilt 1964 · S/N 30-298N7264YYogi Air LLC · Wadsworth, OHBuilt 1964 · S/N 30-299N7265Walker Teresa L · Enid, OKBuilt 1963 · S/N 24-3454N7265PQuinlan John H · Claxton, GABuilt 1961 · S/N 24-2441N7266PGrover Donald G · Canby, ORBuilt 1961 · S/N 24-2442N7269PBoucher Bobbi · Fredericksburg, VABuilt 1961 · S/N 24-2445N7272PMellema Tammo · Dalhart, TXBuilt 1961 · S/N 24-2448N7272YToucan Aviation LLC · Bentonville, ARBuilt 1964 · S/N 30-311N7273PBrice Brandon Scott · Denver, COBuilt 1961 · S/N 24-2449N7274PKeil Ronald B · Lapeer, MIBuilt 1961 · S/N 24-2450N7275YCross John Benjamin · Lake Charles, LABuilt 1964 · S/N 30-314N7277YDouble A Investments Inc · Rowland, NCBuilt 1964 · S/N 30-315N7279YChormicle James R · Littlerock, CABuilt 1964 · S/N 30-317N727DSYso Noz LLC · Grandville, MIBuilt 1958 · S/N 24-276N727RMMarkle Robert L Jr · Cranberry Township, PABuilt 1965 · S/N 30-806N7281PGuardian Peaks Airways LLC · Portland, ORBuilt 1961 · S/N 24-2458N7281YGo For Flight LLC · Minneapolis, MNBuilt 1964 · S/N 30-319N7286YReagan Scott Lllp · Mount Pleasant, SCBuilt 1964 · S/N 30-324N7287PTwo Dot Aircraft LLC · Kalispell, MTBuilt 1961 · S/N 24-2465N7288YN7288y LLC · Manassas, VABuilt 1964 · S/N 30-326N7290PFarmland Investments Inc · Mound City, MOBuilt 1961 · S/N 24-2468N7294YTgaap Inc · Dover, DEBuilt 1964 · S/N 30-333N72DNPostiglione Daniel · West Babylon, NYBuilt 1971 · S/N 24-5006N72MWStaggs Austin · Cudjoe Key, FLBuilt 1963 · S/N 30-171N72SB72 Sierra Bravo LLC · Allegany, NYBuilt 1971 · S/N 24-4969N7300YAdriatic Holdings LLC · Cheyenne, WYBuilt 1964 · S/N 30-341N7302YJohnson Robert Daniel · Seabrook, TXBuilt 1964 · S/N 30-345N7303PWeisend Chad · Peru, INBuilt 1961 · S/N 24-2478N7304YN3024d LLC · Reno, NVBuilt 1964 · S/N 30-349N7305YRegistered aircraftBuilt 1964 · S/N 30-350N7309PEvergreen Underground Water Conservation District · Pleasanton, TXS/N 24-2484N7309YGlaser William Burnett · New Smyrna Beach, FLS/N 30-296N7311YInternational Air Services Inc Trustee · Carson City, NVBuilt 1964 · S/N 30-354N7313YPr Aeronautics LLC · Buffalo, SDBuilt 1964 · S/N 30-356N7316PCase Mark A Trustee · Shady Shores, TXBuilt 1961 · S/N 24-2492
Back to AD 77-13-21