AD 80-25-07 R1
Registered aircraft · 25,369
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-07-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:80-25-07-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:80-25-07-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:80-25-07-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.
N78078International Air Services Inc Trustee · Carson City, NVN7807GLake Of The Woods Aviation LLC · Baudette, MNN7807SSmith Travis T · Watsonville, CAN7807VMad Dog Aviation LLC · Minot, NDN78086Drake Ronald N · Helena, MTN7808VWalker Trenton A · Pittsburg, OKN78095Leuer James A · Encinitas, CAN7809GHodge Aviation LLC · Monroe, LAN7809SJo Ann Miller Marshall · Atlanta, GAN780BGMaw Enterprises USA LLC · Hudson, FLN780DMTexas Barnstormers LLC · Rogers, TXN780ZAGreat Lakes Belle LLC · Furlong, PAN78112Botnick Eric L · Luling, LAN7811SCrop Air LLC · Eaton, CON7811VRivard Jayme · Monterey, CAN78123Rrr3 LLC · Midway, FLN78124Barrow James L · Elizabethtown, KYN78126Orme Jason R · Red Oak, IAN7812VStorrud Jerrel T · Corvallis, MTN78130Garoutte Kirk E · Anchorage, AKN78139Van Straten Patrick F · Shiocton, WIN78142Partyka Kenneth M · Circle Pines, MNN78144Kyzer Aviation Holdings LLC · Fort Mill, SCN7814VBewley Terry V · Longview, TXN78158Hill Donald J · Godfrey, ILN7815GNextgen Flight Academy Inc · Riverside, CAN7815VApice James M · Port Orange, FLN7816SJ Gutwein Aviation LLC · Francesville, INN7816VBrown Timmy L · Poplar Bluff, MON78174Spencer Aviation Inc · Delaware, OHN78179Horgan Robert V Jr · Wolfeboro, NHN7817GBarnhard James L · Washington, DCN7817VWilliams Donald B · Wingate, NCN78180Gatewood Doris E · Stokesdale, NCN78182Ajayi Samuel O · Jacksonville, ARN78183Smolik Vincent C · Ponder, TXN78186Johnson Gavin R · Othello, WAN7818GLippert Charles Phillip · Southwick, MAN7818VGlide Slope Aviation LLC · Flagstaff, AZN78190Prp Aviation LLC · Ocala, FLN78195Mishawaka Pilots Club Inc · Osceola, INN78197Allen County Regional Airport Authority · Lima, OHN7819GCre Aviation Holdings LLC · Ramona, CAN781DBCooper Roy · Lamesa, TXN781FMFmfa Inc · Wilmington, DEN781PGSword Christina Renee · Surprise, AZN781RMHotel Bravo LLC · Madisonville, LAN78207Sherman Todd P · Collinsville, OKN7820VHarris Colby L · Yellville, ARN78215Alvarado Eduardo · Fayetteville, TX
Back to AD 80-25-07 R1