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.
N7055QSeagraves Brad J · Rockwell, NCN7056QFleeman Joseph R · Lawrenceburg, TNN7056VRaw Logistics LLC · Bethel, NCN7057QMindy Limited LLC · Muscatine, IAN7058GDc Aerial Photos Inc · Fredericksburg, VAN70597Rodriguez Hulises · Chula Vista, CAN7059GFrank Todd E · Corsicana, TXN7059VJsb LLC · Chippewa Falls, WIN705CGLewis Scott M · Youngstown, OHN705NRState Of Minnesota · Grand Rapids, MNN705RStatewide Contract Services LLC · Lowell, ORN705RBYakubinis William J · Charlotte, NCN7060QPilot In Command Academy Inc · Miami, FLN7060VRichardson Kaily S · Stanton, TXN7061QMccutcheon Henry C · Frankfort, KYN7062GNorthwoods Aviation LLC · Eagle River, WIN7062PHryniewicki Walter E Jr · Chippewa Falls, WIN7063GL A H Eickhoff Farms Inc · Falls City, NEN7063QCarver Clarence K · Lutz, FLN7065GAden David L · Keenesburg, CON7066GSwindle Don K · Collinsville, TXN7067GAngelle Kelli R · New Roads, LAN7068QWestwind Aviation Inc · Bremerton, WAN7069GAjf Enterprises LLC · Des Moines, IAN7069QFlakker Michael E · Gold Hill, NCN706CFRegistered aircraftN706DAFlycarolina LLC · Charlotte, NCN706DEBradley Aircraft Company LLC · Columbus, INN706HPFlorida Highway Patrol · Tampa, FLN706WCChilcott Bart L · Derby, KSN7070GGade Christopher P · Williston, VTFirst renewal noticeN7070VCraven Bradley A · Logansport, INN7071GWings Over Texas Holdings LLC · Denton, TXN7071QSun Country Aero Club · The Villages, FLN7072GMears Benjamin W III · Eastville, VAN7072QB&R Aircraft LLC · Wadsworth, OHN70739Morey Airplane Co Inc · Middleton, WIN7073GSky Warriors LLC · Hayward, CAN7073KCopper River Airmotive LLC · Copper Center, AKN7073VOwen Greg · Ukiah, CAN7074VRoyal J · Arlington, TXN7074ZCopper River Airmotive LLC · Copper Center, AKN7075GDraper Floyd L · El Paso, TXN7075QCorell Ryan J · Mason City, IAN7076QAbbott Brett C · Leawood, KSN7077VHerrenkohl Robert D · Bay Point, CAN7079VStrandberg Kevin L · Pennock, MNN707ATSpacely Space Sprockets LLC · Aurora, ORN707BCJagair LLC · Riceville, TNN707CGMohler Mark R · Green Cove Springs, FL
Back to AD 80-25-07 R1