AD 91-25-08 R1
Registered aircraft · 657
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:91-25-08-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:91-25-08-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:91-25-08-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:91-25-08-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.
N291ANKb Flies LLC · Amarillo, TXN299GBHoodoo LLC · Missoula, MTN29XXMustang Aeronautics LLC · Chandler, AZN2JAJadair International Inc · Port Washington, WIN2LYMagnolia Air LLC · Starkville, MSN300BRMach Tuck Aero Group LLC · Elkhorn, NEN302MJ425 Partners LLC · Guymon, OKN307FMNorris Aviation LLC · Mansfield, TXN30LTJuans Adios LLC · Newark, DEN30PTGas Aviation LLC · Decatur, TNN311BC311bc LLC · Channelview, TXN311CASouthern Wings LLC · Shreveport, LAN311JHHuaco Aviation LLC · Waco, TXN316EJPinpoint Logistics LLC · Cambridge, NEN316WCEagle Aeronautics LLC · Chicago, ILN31CLg & Gs Holdings LLC · Middletown, DEN31CULovaas Jean H Trustee · Crescent City, CAN31MMPence Air LLC · Edinburg, VAN31WDWestern Dakota Holding Co · Timber Lake, SDN321CEMaroon Sky LLC · Navasota, TXN321HXGggg LLC · Hilton Head Island, SCN333UJUgly Johns Aircraft LLC · Afton, OKN334NCarter-Muthana Aero LLC · Bakersfield, CAN33UWPadf LLC · Fort Collins, CON341RBRomeo Bravo LLC · Thompson, MON342RCHyland'S Pharmacy LLC · Wheeler, TXN344TCInternational Air Services Inc Trustee · Carson City, NVN345TPJet-Force One LLC · Aledo, TXN34ADPremiere Aviation Inc · Concord, CAN34AGJ D Aviation Leasing LLC · Mundelein, ILN353ESNeptune Assets 1 LLC · Lewes, DEN353TSExceptional Housing LLC · Hendersonville, TNN35TYAlpha Aero LLC · Dover, DEN365FDci Air LLC · Dodge City, KSN369RKKrum Force 1 LLC · Wichita, KSN369RMRothschild Jonathan Trustee · Tucson, AZN371SBN333bc LLC · Franktown, CON37404Bear Giant LLC · Eden Prairie, MNN37417Registered aircraftN37424Flight Development LLC · Wichita, KSN37475N37475 Management LLC · Las Vegas, NVN37478Ghareeb Enterprises Inc · Charleston, WVN375KCGuittard Chocolate Holdings Co · Burlingame, CAN377GLDodson International Parts Inc · Rantoul, KSN377JMSanchez Joshua A · Bosque, NMN378KAga Aviation LLC · Lewes, DEN37PSOldenbroek Cornelus Trustee · Medina, TXN37RZOwens Martin · Telluride, CON382BWWd Aviation Group Inc · Atlanta, GAN3908CMccreery Aviation Co Inc · Mcallen, TX
Back to AD 91-25-08 R1