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.
N68814Spooner Wade G · Donalsonville, GAN68815Skippy Aviation LLC · Bridgeport, PAN68816Mirkovic Alex · Friendswood, TXN6881NMorris Michael R · Columbus, OHN6881UElliott James C · Parker, CON6881VCox Colin T · Harbinger, NCN6882UHoecher Robert T · Anchorage, AKN6883NAj Mooney LLC · Port Saint Lucie, FLN6883VHubbell Carl · Crowley, TXN6884HWings Over Texas Holdings LLC · Denton, TXN6884NLutes Kent A · Tazewell, TNN6884USheaffer Bruce R Jr · Lititz, PAN6884VVan Dyck Ryan G · Talent, ORN6885HRasmussen Stewart · Santa Barbara, CAN6885NPoskevich Douglas · Deland, FLN6885UGranier Bernie C Trustee · Bandera, TXN6886HParr Larry · Clarksville, TNN6886NSibille Keith Curtis · Griffin, GAN6886UN6886u Inc · Tucson, AZN6887NColton Frank Lasusa · Harrisburg, PAN6887UAce Aircraft Leasing Inc · Nazareth, PAN6887VHackett Troy D · Riverton, WYN6888HN6888h LLC · Wayne, NJN6888NGrass James Conrad · Phoenix, AZN6888VShepherd Jeffrey W · Woodlawn, TNN688CABetter Southlake Properties LLC · Pagosa Springs, CON688CMIcan Solutions LLC · Fargo, NDN688RMBurton Jason S · Howell, MIN6891HRegistration Pending · Uvalde, TXRegistration pendingN68920Richmor Aviation Inc · Hudson, NYN68926Wings Over Texas Holdings LLC · Denton, TXN6892NStratte Joseph J V · Yakima, WAN6892VFindlay Christopher R · Newark, DEN68934Bapes Debra L · Powell, OHN68938Wingspan 152 LLC · Valparaiso, INN6893URk Management LLC · Garden City, KSN6893VJabes Aviation LLC · Spring Branch, TXN6894UShonrock Clinton O · Los Alamos, NMN6894VFlync LLC · Charlotte, NCN68954Wings Over Texas Holdings LLC · Denton, TXN68956Spartan Education LLC · Tulsa, OKFirst renewal noticeN6895NLadd Noel Joseph Espinosa · Edmond, OKN6895UWoodward Jeffery F · Viroqua, WIN68961Shouling & Philip Enterprise · Lancaster, CAN68963University Of Michigan Flyers Inc · Ann Arbor, MIN6896HBuiqui Aerospace Corp · Kissimmee, FLN6896NHarding Ronald D · Spokane, WAN6897UStyer David B · Pendleton, ORN6897VZottarelli Sean · Fountain Hill, PAN6898HS J Holding LLC · Wilmington, DE
Back to AD 80-25-07 R1