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.
N765GSSolar Joseph R · Punta Gorda, FLN765JVans Rv7a Co LLC · Thornton, CON765LBScott Jacob A · Paso Robles, CAN765MARudy LLC · Middleton, WIN765NDUniversity Of North Dakota · Grand Forks, NDN765PTThompson Philip A · New London, WIN765RKays William G · Millersport, OHN765SATextron Aviation Inc · Wichita, KSN765TXHelms Jim D · Hammond, LAN765XNeel Gregory M · Granbury, TXN7660FDoughty Kirk T · Grapeview, WAN7660GKorn Clifton A · Hayward, WIN7660KGbq LLC · New Prague, MNN7660PRegistered aircraftN7660RWare Joshua A · Inwood, WVN7660WMelberg Bruce W · Weatherford, TXN7661DAndrews David L · Redvale, CON7661FBass Fred Lee III · Birmingham, ALN7661HVan Wagner Aerial Media LLC · Hollywood, FLN7661JMitchell Edson · El Dorado Hills, CAN7661KJenkins James L · Lake Stevens, WAN7661LDoren Patrick E · Wasilla, AKN7661WLund Dana K · West Covina, CAN7662FFreeman Mark J · Discovery Bay, CAN7662GB&R Aircraft LLC · Wadsworth, OHN7662JBurns Christopher Jason Gary · Natrona Heights, PAN7662PRemund Richard W · Slate Hill, NYN7663FBandstra James R · Big Rapids, MIN7663HZweifel Douglas L · Anchorage, AKFirst renewal noticeN7663ZGieseke Joe · Tuttle, OKN7664DCachorro Cattle Co · Granbury, TXN7664FSkyfusion II LLC · Atlanta, GAN7664JTrue Arrow Aviation LLC · Cloverdale, CAN7664KHolzaepfel Carl E · Baytown, TXN7664MMalinchak Louis Jr · Bristow, OKN7664PSandpiper Aviation LLC · Carson City, NVN7664YSummit Flight Academy LLC · Peculiar, MON7665CIndian Hills Community College · Ottumwa, IAN7665DMehling Craig · Hardin, MTN7665KHicks Robert W · Petersburg, MIN7665PBeatty Charles T · Mesa, AZN7665SPiercy Ronald S · Moses Lake, WAN7666GHudson Daryl J · Redwood Valley, CAN7666JCavallaro Jack C · Jordan, NYN7666WFields Steve · Versailles, MON7667CDoral Aviation LLC · Jefferson Hills, PAN7667GBrooks Alan G · Kernersville, NCN7667HKrogstad Paul D · Juneau, AKN7667PGoble John H · Cresson, TXN7667WRegistration Pending · Hickman, CARegistration pending
Back to AD 81-18-04 R2