AD 81-18-04 R2
Registered aircraft · 81,733
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:81-18-04-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
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:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') 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.
N9081LReed William B Trustee · San Jose, CAN9081VSale Reported · Phoenix, AZSale reportedN9081WStickley John E · Lothian, MDN90829Leading Edge Aviation Consultants LLC · Windsor, CTN9082DLeahy Garry E · Van Wert, IAN9082LSmethurst Jeffrey C · San Francisco, CAN90839White Jake W · San Antonio, TXN9083BNorth Coast Flight School Inc · Meadville, PAN9083DSachs Randy S · S Huntington, NYN9083KShuey Robert D III · Albertville, ALN9083LPeavy Michael J · Chico, CAN9083NKnoxville Flyers Inc · Knoxville, TNN9084FIsland Bound LLC · Dunedin, FLN9084VLinear Air LLC · Herriman, UTN9085JBligh Michelle C · Oceanside, CAN9085KSale Reported · Grayling, MISale reportedN9085LBlanton Jeffrey D · Valley Center, KSN9085WColip Lydia · Bowling Green, INN9086DDarrow John K · Soldotna, AKN9086JBrogan William J · Port Matilda, PAN9086KMedia Stew LLC · Carson City, NVN9086ZCy Air LLC · Springfield, MON90874Myers Brian R · South Bend, INN90878Schmoll Steven D · Zimmerman, MNN9087DBolden Family Farms · Little Rock, ARN9087LDeterding Jim L · Pond Creek, OKN9087VPyne Jeffery G · Waxhaw, NCN9087WKohlhardt Ronald C Trustee · Cameron Park, CAN90882Bucciarelli Dominick F · Pueblo, CON9088DMetro Aircraft Co · Bloomington, MNN9088EBrink Kirk H · Greeneville, TNN9088JRiggins Ryan W · Durango, CON9088LLegends LLC · Willow, AKN9088QGolf Foxtrot Yankee LLC · Kingston, NYN9088UPennington Daniel W · Rutland, VTN9089K&M Land Surveying Inc · Lincoln, NEN90898Nation Steven R · Hurricane, UTN9089CCrew Sourcing Inc · Wilmington, DEN9089HDavis Joseph S · Andalusia, ALN908AArcher Aero LLC · Wilmington, DEN908AFRobinson Craig M · Colfax, CAN908AGPeregrine Howard Aeroflight Owner LLC · New Orleans, LAN908AZWingsleasing LLC · Wichita, KSN908BLBoudreaux Jacques P · Shreveport, LAN908CPCivil Air Patrol Inc · Maxwell Afb, ALN908DRRhodes Dennis R · Taylorsville, GAN908ENEl Aviation LLC · Alpena, MIN908EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN908FGRidgeline Assets LLC · Wilmington, DEN908GDCorpus Terra Investments LLC · Hialeah, FL
Back to AD 81-18-04 R2