AD 80-25-07 R1
Registered aircraft · 25,368
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.
N94247Solberg Aviation Co Inc · Whitehouse Station, NJN9424EAero Equities LLC · Ventura, CAN9425HWingsleasing LLC · Wichita, KSN9425VEcaviators LLC · Wilmington, DEN9426EDarcy Aviation LLC · Danbury, CTN9426VTwo Guys One Plan LLC · Clermont, FLN94270N94270 LLC · Chesterfield, NJN9427VBrack Enterprises LLC · Indianapolis, INN94286Purdue Aviation LLC · West Lafayette, INN9428VMcconnaughhay Ken · Searcy, ARN94292My Way Aviation LLC · Weston, FLN9429VFrankel Daniel A · Madison, OHN942AZAz2025 LLC · Miami, FLN942TBBailey Thomas R · Benton, KYN9430VRuff Deborah · Auburn, CAN9431TDavis Gary L · Burleson, TXN9432DRegistered aircraftN9433EKozma Peter · San Diego, CAN9433LCivil Air Patrol Inc · Maxwell Afb, ALN9434VKnackstedt Dennis R · Winfield, KSN9435BPalladino Michael A · Pinehurst, NCFirst renewal noticeN9437DRichmor Aviation Inc · Scotia, NYN9438HBering Capital LLC · Anchorage, AKN9438VPrestridge Jacob · Portland, ORN94397Koenitzer Judson B · Chetek, WIN9439BAv Dak Inc · Crystal, NDN9439ESilverhawk Aviation Academy LLC · Caldwell, IDN9439YR C S Drilling Company Inc · West Lake Hills, TXN943KSStark James E Trustee · Sun City, AZN943RWBluflyt LLC · Athens, WVN943SASunrise Aviation Inc · Ormond Beach, FLN94400Macinnis James Michael · Copley, OHN94401Maui Aviators LLC · Pukalani, HIN9440VVanhorn Jonathan F · Laguna Hills, CAN9441VKarge Robert F · Peachtree City, GAN9442Winger Aviation LLC · Palatine, ILN94429Wisconsin Aviation Inc · Watertown, WIN9442RPauly Jeff D · Watkins, MNN9442VFlight Operations Academy LLC · Prescott, AZN9443HAllport Bruce E · North Hollywood, CAN9443LTdz Aircraft Holdings LLC · Dover, DEN94447Flightime LLC · Stuyvesant, NYN9444HPrestige Worldwide Aerospace LLC · Panama City, FLN9445DTriple Fes LLC · San Antonio, TXN9445HBrown Max K · Cushing, OKN9447HLang Julia A · Greensburg, PAN9447LAirplane And Drone Flight Instruction LLC · Orlando, FLN9448TSanders Robert · Harlingen, TXN9449VClark Jeff W · Piedmont, MON944CBCalifornia Baptist University · Riverside, CA
Back to AD 80-25-07 R1