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.
N8334LAirspeed Marketing Bravo LLC · Phoenix, AZN8334VRegistration Pending · Milton, FLRegistration pendingN8335VLisoski Derek L · Clark Fork, IDN8337VWydronek Joseph A · Tucson, AZN8338LTreimer Aviation LLC · Davenport, IAN8338VGustafson Cody A · Corvallis, ORN8339LRohrbaugh David J · Oakland, MDN833CBDehaan David J · San Diego, CAN833RTNash LLC · Carbondale, ILN833TWDesert Wind Wings LLC · Mesa, AZN8340LHess Garrett J · Fullerton, CAN8342VPrecision Aerial Ag LLC · Seneca, KSN8344LHeir Borne Flying Club Inc · Minot, NDN8346LJones Mark B · Angleton, TXN8346VLovley Linda C · Jordan, MNN8347LSchye Ted E · Billings, MTN8348LPrice William B · Lamar, SCN8349EArment C Randall · Valentine, NEN834GTIlmberger Stephen R · Sisters, ORN8350VMertz Rachel A · New Ulm, MNFirst renewal noticeN8351LPlane Junkies LLC · Dover, DEN8352LFielding David · Scarborough, MEN8353VN8353v LLC · Monroe, LAN8354LEast Texas Imperial Petroleum LLC · Flint, TXN8356ESky West Aviation Inc Trustee · Albuquerque, NMN8356VGroh David A · Mason, MIN8357VHaas Daniel S · Camarillo, CAN8358LOc Flight Lessons LLC · Costa Mesa, CAN8359LBay Lux Ventures LLC · Tampa, FLN8359VCressman Scott M · Mount Pleasant, TXN8361LMolid Robert J · Dubuque, IAN8365LHarbour Aviation LLC · Weatherford, TXN8365VJarvis Stormy A · Anchorage, AKN8366LCurwin Randy S · Villa Rica, GAN8367LRay Allens Electronics Inc · Butler, GAN8368LMeltzair LLC · Fryeburg, MEN8368VRare Air LLC · Forsyth, MTN8369LInternational Air Services Inc Trustee · Carson City, NVN8369VCentral Virginia Aviation Inc · N Dinwiddie, VAN836DBR&L Sales LLC · North Vernon, INN8371VPrairie Thermals LLC · Brookings, SDN8372LRed Sky Aviation LLC · Livermore, CAN8372VVarwig Korrey L · Peoria, ILN8373LFaulkner Jeannine P · Bethel, AKFirst renewal noticeN8373VSeidler Marlyn L · Underwood, NDN8374LGeneral Aviation LLC · Henderson, NVN8374VDexter Fred M · Live Oak, FLN8375VCarll Elizabeth M · Chicago, ILN8376VKirkeby Dean A · Clark, SDN8377VWeber William A · Brodhead, WI
Back to AD 80-25-07 R1