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.
N7565VRehwald William J S · Santa Monica, CAN7565WHurdle Scott R · Clemmons, NCN7565XDonaldson Bros Flying Circus LLC · Spencer, IAN7565YVictor Robert W Jr · Topeka, KSN7566KHorseshoe Bar Land & Livestock LLC · Gillette, WYN7566PLambert Dwight E · Albany, ORN7566RHill Bruce W · Newton, ILN7566WStrobel Gary D · Mooresville, NCN7566YS & D Adventure LLC · Middletown, DEN7567FMansfield Heliflight Inc · Milton, VTN7567GWhipple Eugene B · Mchenry, ILN7567HGuidici Aidan G · San Antonio, TXN7567JFidelis Universal Technology Inc · Chino Hills, CAN7567PSteigerwalt Jeffrey A · Lehighton, PAN7567RThomas Baley B · Zavalla, TXFirst renewal noticeN7568FTranbarger Tad E · Macksville, KSN7568JRoberts Donald B · Albion, ILN7568PBroussard James · Colmesneil, TXN7568TSale Reported · Phoenix, AZSale reportedN7568VPawlish Andrew M · Fort Collins, CON7568YAviation Associates LLC · Oxford, MDN7569DThiele Tamara L · Anchorage, AKN7569FMainero Tanner R · Chehalis, WAN7569GAirborne LLC · Wilmington, DEN7569HCompton Steven · East Northport, NYN7569PBrowne Donald K · Labelle, FLN7569VLiberty Capital LLC · Kalispell, MTN756AAtp Aircraft 6 LLC · Wilmington, DEN756ALLange Robert Brandt · Newport Beach, CAN756AWLincoln Skyways Inc · Lincoln, CAN756BCBuchanan Bryan DBA · Gig Harbor, WAN756CCBrown Travis J · Lincoln, ALN756CKMckee Jay Russell · Baggs, WYN756CXCahill Brian H · Valley Center, CAN756DFFroster David C · Ravenna, MIN756EBTak Holdings LLC · Pleasant View, TNN756EFTim Daniels Inc · Labelle, FLN756EMPacific Aircraft Management LLC · Tacoma, WAN756EUFisher Air LLC · Cardington, OHN756EVOyarzo Benjamin C · Cascade, IDN756EZBear Branch Hedeen LLC · Meridian, IDN756FCSunny Aviation Investments Inc · San Francisco, CAN756GAtp Aircraft 9 LLC · Wilmington, DEN756GEAbraham Curtis L · Byron, WYN756GLLawrence Cyril Leonard · Merced, CAN756GYLake Superior College · Duluth, MNN756GZGlasow Zachary · Klamath Falls, ORN756JBRocky Mountain Great Planes LLC · Loveland, CON756JLN756jl LLC · Virginia Beach, VAN756JPHjs Aviation LLC · Fort Collins, CO
Back to AD 81-18-04 R2