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.
N9582WBlomquist Kevin C · Kanab, UTN95831Space Coast Aircraft Co · Merritt Island, FLN9583BBurke Larry Ryan · Pembroke, GAN9583JTevik Michael A · Provo, UTN95840Lane Community College · Eugene, ORN9584B360 Marine · Bristol, RIN9584JLow Wing LLC · Upland, CAN9584MKing Wesley C Jr · Dayton, OHN9584PSugarbush Soaring Assn Inc · Warren, VTN9584QHoward Genetics Inc · Ardmore, OKN9584VStick & Rudder Club Inc · Waukegan, ILN9584WMitchell Gary N · Kansas City, KSN9585CEldredge Matthew · Locust Grove, GAN9585DArnt James Robert Jr · Worthington, MNN9585JHaj Aviation Inc · Cypress, TXNon-citizen corporation, flight hours not reportedN9585LEight5lima LLC · Phoenix, AZN9585MScheuneman Carl V · Plano, TXN9585UBuhman Kevin H · Marysville, WAN9585VHarrington Aviation LLC · Scarborough, MEN9585WRandolph Richard A · Gallipolis, OHN9586DHauser Nathan S · Newark, DEN9586JGeorge Neal E · Crestview, FLN9586LJones Jr Lee S · Kearneysville, WVN9586MH W S Enterprises Inc · Canal Fulton, OHN9586WAlpha 3 LLC · Troy, KSN9587AMckie Voerste Travis K · Chatsworth, GAN9587JScott Jeremy A · Newark, OHN9587LWiles Robert B · Biloxi, MSN9587MNorman Bradley T · Glen Rose, TXN9587SReberg Timothy J · Bayport, MNN9587UKramer Andrew J · Sacramento, CAN9587VPinnick Brent E · West Baden Springs, INN95880Nevels Donald L · Everton, MON9588DGardner Brian D · Mesa, AZN9588MDrietz Dallas A · Lake Benton, MNN9588URgm LLC · Missoula, MTN9588VKachemak Bay Flying Service Inc · Temple, TXN9589HFryar Scott D · Starke, FLN9589LVincent Jared H · Fairhope, ALN9589SJones Daniel S · Panama City Beach, FLN958AMurray Martha D · Moneta, VAN958BPiper Aircraft Inc · Vero Beach, FLN958CPJoslyn Larry J · Las Vegas, NVN958DSDelta State University · Cleveland, MSN958EGGores Thomas J · Franklin, WIN958EREmbry-Riddle Aeronautical University · Daytona Beach, FLN958KMEast Baton Rouge Parish Mosquito · Baton Rouge, LAN958LRegistered aircraftN958LBBevilacqua Jeffrey L · Thousand Oaks, CAN958MLLazarowicz Michael J · Port Clinton, OH
Back to AD 81-18-04 R2