AD 2000-23-21
Registered aircraft · 47,138
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:2000-23-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:2000-23-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:2000-23-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:2000-23-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.
N3292MHyannis Air Service Inc · Hyannis, MAN3292UAnnecchini Frank C Jr · Overland Park, KSN3293DGuilliams Carl · Gilbert, AZN3293YKiedinger John D · Burleson, TXN3294UWidener Christine A · Tucson, AZN32959Hill Ryan D · Fresno, CAN3295YReid Brian M · Boise, IDN3296PMadlener Michael J · Pahrump, NVN3296SBeekman Steven J · Stephenson, MIN3296UBierer David E · Victor, MTN3296YBeckord Aaron P · Tacoma, WAN3297YMust Dash Rides Flying Club LLC · Raleigh, NCN3298SHolloway Cody L · Belle Plaine, KSN32999Mil2atp Inc · Pikeville, NCN3299SS V Aeronautics LLC · Afton, WYN3299URichardson Ronnie L Jr · East Wenatchee, WAFirst renewal noticeN329CBullard Aviation Services Inc · Ormond Beach, FLN329EMRmb Of Mn LLC · Watkins, MNN329JHAlliance Aircraft Sales Inc · Pierre, SDN329JSHc Rec LLC · Georgetown, KYN329JTAms Leasing LLC · New Oxford, PAN329RMNova Aviators LLC · Great Falls, VAN329RTRegistered aircraftN329SFChampion Air LLC · Louisville, KYN329SRHorn Russell · Woodbridge, CAN329WB329 Whiskey Bravo LLC · Provo, UTN329WTMach 10 Aviation LLC · Portland, ORN329XLima 2 Aviation Of Mississippi LLC · Bogue Chitto, MSN32AJFreedom Plane LLC · Freedom, NHN32AKHummel Karl · Brooklyn, NYN32ATSavrey LLC · Austin, TXN32AZChristian Brothers Aviation LLC · Dalton, GAN32BHBechtold Brahm Hellman · Parker, CON32BLHeiser And Associates Inc · Novato, CAN32CDN32cd Aviation Services LLC · Aptos, CAN32CEMiller David J · Naperville, ILN32CHHeckler Gary C · Carefree, AZN32CLStandish David Dewitt · Billings, MTN32CWMcdiarmid Jeffrey · Walla Walla, WAN32DBCarpenter Forrest A · Berthoud, CON32DFMillford Aviation LLC · Waukesha, WIN32DGRous LLC · Fredericksburg, VAN32DLLarson David W · Palmer, AKN32EEMcginnis Patrick J · Friendswood, TXN32EKTips Dan N · Plano, TXN32EPCaravelle Aviation LLC · Farmingdale, NYN32ETFront Side LLC · Heber City, UTN32FCZimin Transportation LLC · South Naknek, AKN32FLArmy Aviation Heritage Foundation And Museum · Hampton, GAN32GRAngella Tony · Fort Lauderdale, FL
Back to AD 2000-23-21