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.
N82241Naranjo Navarro Jose N · Las Vegas, NVN8224GSkylarkers Inc · Farmington, NMN8224KPelayes Tristan · Temecula, CAN8224NDc Aviation LLC · Appleton, WIN8224WDavis William M · Chattanooga, TNN8224YWoodard Earl G Jr · Danville, GAN82253Dirt Strip Dirtbags LLC · Whitefish, MTN82255Quinn John J III · Merritt Island, FLN82259Pedersen Eric D · Mccall, IDN8225AFast Track Aircraft LLC · Oxford, MSN8225CHastings Heidi R · Wasilla, AKN8225PTenntech Corp · Wilmington, DEN8225UNagy John F · Whittier, CAN8225VRunge Thomas A · Sterling, VAN8225WLewis Devin H · Lacey, NJN8225XWarren Dennis J · Denver City, TXN8225YInternational Air Services Inc Trustee · Carson City, NVFirst renewal noticeN8226CTyler Joseph Virgin · Wasilla, AKFirst renewal noticeN8226HForward Jeffrey C · Oakes, NDN8226VParchman Travis R · Philadelphia, PAN8226YC P L Air LLC · Middletown, DEN82274Harris James M · Bemidji, MNN8227GKritz Eric J · Gualala, CAN8227NRegistration Pending · Dawsonville, GARegistration pendingN8227WQuarter Circle E Enterprises Inc · Yorba Linda, CAN82285Horton Charles M · Wilkeson, WAN82286Registration Pending · Bullhead City, AZRegistration pendingN8228WKoaks Aviation LLC · Farmers Branch, TXN82293Egolf Mark A · Nine Mile Falls, WAN8229FSterling Aviation · Concord, CAN8229GEastman Gary Lynn · Penn Valley, CAN8229PMacair Aviation LLC · Xenia, OHN8229WRab Aviation Photography LLC · Lanexa, VAN822ABRice Allen J · Steinhatchee, FLN822ARCapen Ralph E · Laurel, DEN822BWAa-Aero Inc · Fairfield, NJN822CGRepublic Wings LLC · Moseley, VAN822CSGottemoeller Aircraft Leasing Ltd · Fort Loramie, OHN822DJCoscio David V · Kings Beach, CAN822ESouthern Aircraft Consultancy Inc Trustee · Casper, WYN822EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLN822FHawaii Pacific Aviation Inc · Kailua Kona, HIN822GCareer Pilot Training LLC · Wilmington, DEN822GBBrown Thomas D · Griffin, GAN822GCHigh Mark C · Tooele, UTN822JSN822js LLC · Norcross, GAN822KTJet Air Inc · Iowa City, IAN822LMLehberger Charles W · Madison, CTN822MLMojo Flight Group LLC · Gainesville, GAN822MNLucky B Aviation LLC · Wilmington, DE
Back to AD 81-18-04 R2