AD 2006-10-21
Registered aircraft · 44,908
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:2006-10-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:2006-10-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:2006-10-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:2006-10-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.
N24747Peachey Farms LLC · Decatur, IAN24748Delta State University · Cleveland, MSN2474CArchitectural Industrial Rentals LLC · Wilmington, DEN2474YLogan Air Services LLC · Logan, UTN24756Wings Over Texas Holdings LLC · Denton, TXN2475LDeralex Airways LLC · Miami, FLN2476ESkyspot Advertising LLC · Lakeland, FLN2476JCrosshares Aircraft Holdings LLC · Plymouth, INN2476YAmerican Aviation Inc · Brooksville, FLN2477FChristiansen Aviation LLC · Wilmington, DEN2477SAverett University · Danville, VAN2477T7 Shooter Ranch LLC · Aledo, TXN24780San Diego Flight Training International Inc · San Diego, CAN24783Elite Approach LLC · Chesterfield, MON24787W Tech Consulting Inc · Wilmington, DEN2478T5b Aviation LLC · Duncan, OKN2479BPac 2 LLC · Clinton, IAN2479MSt Thomas Jet Center Flying Club LLC · Lewes, DEN247AUPeregrine Howard Partners II Lp · New Orleans, LAN247BCPlane Nutz LLC · Sugar City, IDN247BW7bw LLC · Kalamazoo, MIN247CTConsolidated Technologies · Woodbury, MNN247DN247d LLC · Creedmoor, NCN247DEKtor LLC · Carlsbad, CAN247FMansfield Heliflight Inc · Milton, VTN247GHanson James A · Bandon, ORFirst renewal noticeN247GWRotondo Joseph N · Baden, PAN247HBUtz Joel S · Austin, TXN247JTSorensen Jeffry Dale · Wellsville, UTN247KTFly Kt LLC · Coconut Creek, FLN247LWHailey & Harmony Enterprises LLC · Las Vegas, NVN247MAWanda Collins Professional Pilot Services LLC · College Station, TXN247MGGeorgia Aviation Authority · Eastman, GAN247RBernard Phillip · Washougal, WAN247RDDga Aviation LLC · North Little Rock, ARN247SOrr Monte L · Hay Springs, NEN247SARoss Branta Enterprises · Boise, IDN247STGustaf Christopher A · Madison, WIN247TFVisionary Holdings LLC · Missoula, MTN247UTRegistration Pending · Xxx, OKRegistration pendingN247WHHenderson Woodrow C · Pleasanton, TXN2480VLyons Emily A · Homewood, ALN2481TWidell Randall Ross · Wilsonville, ORN2485RGriffith Kyle R · Talihina, OKN2488PPs Engineering Inc · Lenoir City, TNN248AMDesfosse Donald J Trustee · Andover, MAN248BFotheringham Jack · Palmer, AKN248BFBohmer Alexander J · Moorhead, MNN248CBCalifornia Baptist University · Riverside, CAN248DBAce Helicopters LLC · Colfax, WI
Back to AD 2006-10-21