AD 94-05-05 R1
Registered aircraft · 26,231
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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.
N32572Buell Robert A · Punta Gorda, FLN32578James Stanley J · Williamson, GAN3257KKrueger Hendrick · Rockport, TXN3257LBeene Jerry · Bulverde, TXN3258VBoard Of Trustees Of Western Michigan University · Battle Creek, MIN32598Benson Edward A · San Antonio, TXN3259AHalle Michael P · Livingston, TXN3259JPreflight Aviation Inc · Oregon, WIN3259VMaynard Richard L · Vilonia, ARN325TMKincer Charles L · Richmond, MEN325UKilo Fox Aviation LLC · Saint Joseph, MIN3260LHerring Rhett H · College Station, TXN3262HMosier Charles A · Havana, FLN3262JBlock Oliver L · Nashville, TNN3262LKd3262 LLC · Downers Grove, ILN32635Smith James E Trustee · Kalispell, MTN3263KJennings Shawn Thomas · Chetek, WIN3263LSale Reported · Arcata, CASale reportedN3264JB&K Used Auto & Equipment Llp · Fountain Run, KYN3264KBudde Bobby M Jr · San Jose, CAN3264PMoore Jeffrey · Cleveland, NYN3265JFord-Umfuhrer Austin Donavan · Carrollton, GAN3266LWolverine LLC · Roanoke, VAN3267HZemaitis Richard A · Birchwood, WIN3267KShay John D · Covina, CAN3267LBetter Fly Inc · Litchfield, ILN32686Fortney Deborah S · Union City, CAN3268AKistler Michael J · Wasilla, AKN3268JMiller Robert F · Locust Grove, GAN3268NBenninger Timothy A · Cobleskill, NYN3269KJones Michael R · Riverside, CAN326HBTimbs Gary · Ontario, CAN326HSCarson Joe F III · Jackson, MSN326YRusu Alexandru · Caldwell, IDN32708Huppert Gerald P · Palmer, AKN3271AJohnson Jackson B · Wasilla, AKN3271LHenson Raul Andre · Fox Island, WAN32721Lakeland Aero Club Inc · Lakeland, FLN3272KBossola Raymond L · Suffolk, VAN3274JOgrady John Thomas · West Chicago, ILN3274LHk Ventures LLC · Paynesville, MNN32752Shipman William L · Mc Calla, ALN3275LMil2atp Inc · Pikeville, NCN3276HRoush Jeremy P · West Terre Haute, INN32772Lohse Flying Service Inc · Carter, MTFirst renewal noticeN3277ALandry Anthony H · Port Orchard, WAN3277JBranson William E · Stokesdale, NCN3277LDeshpande Peter N · Eugene, ORN3278JSarrafi Frank H · Tarzana, CAN3278LPeterson Donald A · Ajo, AZ
Back to AD 94-05-05 R1