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.
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
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.
N7249PDavis Scott · Bingham, NEN7249YCt Capital LLC · Austin, TXN724BMJensen William B Jr · Huntington, NYN7250PTrayer Kevin B Trustee · Haslet, TXN7252PSchaefer Hugh W · Merrick, NYN7252YGuyer James · Billings, MTN7253YJednacz Scott T · Bixby, OKFirst renewal noticeN7254YSpldkd LLC · New Richmond, WIN7255PKubik Rodrick D · Waukee, IAFirst renewal noticeN7257YRice Clark D · Anaconda, MTFirst renewal noticeN7258YJprg Aviation Inc · Orlando, FLN7260PPotts Leah Marie · Roanoke, VAN7260YDeuce Aire LLC · Middletown, DEN7261YKocak Robert G Jr · Peoria, AZN7262PParker Dennis Scott · Lubbock, TXN7263YRag Wings And Radials Aircraft Leasing LLC · Georgetown, DEN7264YYogi Air LLC · Wadsworth, OHN7265Walker Teresa L · Enid, OKN7265PQuinlan John H · Claxton, GAN7266PGrover Donald G · Canby, ORN7269PBoucher Bobbi · Fredericksburg, VAN7272PMellema Tammo · Dalhart, TXN7272YToucan Aviation LLC · Bentonville, ARN7273PBrice Brandon Scott · Denver, CON7274PKeil Ronald B · Lapeer, MIN7275YCross John Benjamin · Lake Charles, LAN7277YDouble A Investments Inc · Rowland, NCN7279YChormicle James R · Littlerock, CAN727DSYso Noz LLC · Grandville, MIN727RMMarkle Robert L Jr · Cranberry Township, PAN7281PGuardian Peaks Airways LLC · Portland, ORN7281YGo For Flight LLC · Minneapolis, MNN7286YReagan Scott Lllp · Mount Pleasant, SCN7287PTwo Dot Aircraft LLC · Kalispell, MTN7288YN7288y LLC · Manassas, VAN7290PFarmland Investments Inc · Mound City, MON7294YTgaap Inc · Dover, DEN72DNPostiglione Daniel · West Babylon, NYN72MWStaggs Austin · Cudjoe Key, FLN72SB72 Sierra Bravo LLC · Allegany, NYN7300YAdriatic Holdings LLC · Cheyenne, WYN7302YJohnson Robert Daniel · Seabrook, TXN7303PWeisend Chad · Peru, INN7304YN3024d LLC · Reno, NVN7305YRegistered aircraftN7309PEvergreen Underground Water Conservation District · Pleasanton, TXN7309YGlaser William Burnett · New Smyrna Beach, FLN7311YInternational Air Services Inc Trustee · Carson City, NVN7313YPr Aeronautics LLC · Buffalo, SDN7316PCase Mark A Trustee · Shady Shores, TX
Back to AD 77-13-21