AD 87-20-03 R2
Registered aircraft · 54,015
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:87-20-03-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
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:87-20-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2') 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.
N9941MAlaska Aircraft Leasing LLC · Silverdale, WAN9941VMorris Gray S · Chugiak, AKN9941ZParagon Air Group · Fort Worth, TXN9942MAlaska Aircraft Leasing LLC · Silverdale, WAFirst renewal noticeN9942QWarren John Russell · Los Alamos, NMN9943ASipple Ronald W Jr · Gardner, KSN9943ELerud Peder E · Stockton, CAN9943MBristol Bay Air Service Inc · Dillingham, AKN9943QGrove Todd M · Lake Stevens, WAN9943VNewsom John · Lubbock, TXN9943XN63e LLC · Fallon, NVN9943ZState Of Maine Department Of Agriculture · Old Town, MEN99442Sale Reported · Kissimmee, FLSale reported, pending cancellationN9944ESw Aviation LLC · Norman, OKN9944NJungclaus Karl F · Piedmont, SDN9944QSkywarrior Flight Training Inc · Pensacola, FLN9944RCentral Virginia Aviation Inc · North Dinwiddie, VAN9944VHinkes Michael T · Fairbanks, AKN9944XChristian Dana J · Bozeman, MTN9944ZChaparral Air Group · Grapevine, TXN9945EWilcox John C · Aurora, NEN9945HCbw Holdings LLC · Columbia, TNN9945QClassic Air Aviation LLC · Mesa, AZN99465Farzam Hamid · Newington, CTN99467Civil Air Patrol Inc · Maxwell Afb, ALN9946BFuehrer John G II · Ephrata, PAN9946ELorenz Gary W · La Mesa, CAN9946MGrant Aviation Inc · Anchorage, AKN9946QHorizon Aviation LLC · Sinclair, MEN9946TKruger Matthew J · Pine Island, MNN9946XBarber Edward G Jr · Anchorage, AKN9947BClarke Adam M · Lompoc, CAN9947CLoftin Aviation Group LLC · Suwanee, GAN9947EAstle James H · St John, KSN9947GArthur Aviation LLC · Arthur, NDN9948Barron Jon M · Perry, MON9948AHoatson Larry · Yucaipa, CAN9948MGrant Aviation Inc · Anchorage, AKN9948TMoulton Robert J · Filer, IDN9948VSchultz Vaughn P · Marysville, CAN9948ZAlien Invaders LLC · Medina, WAN9949NFox Heather J · Bettles Field, AKN994CDNavair LLC · Mount Vernon, OHN994JPHinen Paul H · Soap Lake, WAN994NACurry Lloyd F · Karnack, TXN994NZFrakes Stephen A · Frisco, CON994RJAirline Pilot Careers LLC · Champlin, MNN994RSShane Richard D · Canandaigua, NYN99501Bennett Gary R · Anchorage, AKN99508Lee Randall Ross · Houston, TX
Back to AD 87-20-03 R2