AD 80-25-02 R2
Registered aircraft · 6,349
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:80-25-02-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:80-25-02-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:80-25-02-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:80-25-02-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.
N9381LRyback Andrew · Ocala, FLN9382LCox Steven G · Colorado Springs, CON93831Christiansen Aviation LLC · Wilmington, DEN9383LRegistration Pending · Omaha, NERegistration pendingN9384LBethel Thomas G N · Moultonborough, NHN9386LMiller Michael C · Bullard, TXN9387TAnczarski John J · Ringtown, PAN93927Williams Michael T · Leo, INN9394TRiepe Andrew P · Rossier City, LAN93980Pruitt Hugh A · Ardmore, OKN93989Sunrise Aviation Inc · Ormond Beach, FLN9398LBarlow Robert K · Lakeway, TXN939ABTractorboyflys LLC · Sugar Land, TXN939ACFlorida Flight Training Center Inc · Venice, FLN93BYPearce Ricky A · Parsons, KSN93DJMacnicol Robert D · Bartow, FLN93ESTudor Daniel · Harlowton, MTN94006Leading Edge Aviation Inc · Doylestown, PAFirst renewal noticeN9402LMacgillivray Ian Spencer · Bakersfield, CAN9403LZachary Taylor M · Queen City, TXN9404LPeak 8 Aviation LLC · Breckenridge, CON9405LVann Dudley C · Greenville, NCN9407LBowling David L · Indianapolis, INN94097Registration Pending · St Simons Island, GARegistration pendingN940GJohnson Jay A · Daytona Beach, FLN940RJLaguna Verde Leasing Inc · Wilmington, DEN94112Cooper Robert Jb · Wichita, KSN94118Unique Educational Experiences · Long Beach, CAN9411TLopez Geo U · Round Rock, TXN94138Space Coast Aircraft Co · Merritt Island, FLN9413LFeinstein David · Milford, CTFirst renewal noticeN94140Ng Calvin · Houston, TXN9416LOjeda Kathleen · Pearland, TXN94179Aerophile LLC · Wilmington, DEN9419LDorman Zachery Ray · Mountain City, TNN9420LEddleman Russell K · Phoenix, AZN9422LGryske Kenneth R · Pinehurst, NCN94247Solberg Aviation Co Inc · Whitehouse Station, NJN9425LSiegel R J · Bayside, WIN9426LKohout John S · Terrell, TXN94270N94270 LLC · Chesterfield, NJN9427LGaiss Randolph M · Lake City, FLN94286Purdue Aviation LLC · West Lafayette, INN9428LBarrett Lewis E II · Woodstock, GAN94292My Way Aviation LLC · Weston, FLN942WGPotter Mark H · Santa Rosa, CAN9430LArnason Matthias J · Portland, ORN9431LCordova Zachary · Brighton, CON9431TDavis Gary L · Burleson, TXN9432LMendelson Edward · Philadelphia, PA
Back to AD 80-25-02 R2