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.
N6123DCampi Curtis · Boulder City, NVN6123FJws Aviation LLC · Edina, MNN6123NPfisters Flying Wahine · Waialua, HIN6123QAirflair Inc · Maurice, IAN6123VWings Over La Aviation LLC · Van Nuys, CAN6124DWegener Flying Services LLC · Indialantic, FLN6124JCrews Aaron Gregory · Boone, IAN6124NPacific Coast Air Museum · Santa Rosa, CAN6124QLewis Chip M · Eau Claire, WIN6124TBanjo Ben Aviation LLC · Kilgore, TXN6125BBv Road And Site LLC · Penfield, NYN6125LJohnson Gerald A · Sedro Woolley, WAN6125PThomas Roger · Hudson, OHN6125ZSvendsen Jon A · Wasilla, AKN61260Syracuse Flight School Inc · Syracuse, NYN6126DNeal Brian C · Monrovia, CAN6126MBishop Aeronautics LLC · Helena, MTN6126PDallas Jets Group LLC · Canton, TXN6126SWise Joseph · Kilgore, TXN6126TGuida Associates Consulting Inc · Sandpoint, IDN6126WMatthews James C · Gilbert, SCN6127AGilfert Thomas E · Selinsgrove, PAN6127HBless Howard P · Pennsburg, PAFirst renewal noticeN6127MOhman Victor N · Glenrock, WYN6127VSorbi Aviation Inc · El Cajon, CAN6127WLa Aviation Ltd · Wilmington, DEN6127ZSimmons Aviation Services LLC · Pawcatuck, CTN61289Huff Zachary Daniel · Mesa, AZN6128PTango Alpha Sierra LLC · Berthoud, CON6128TStone Mark · Scotts Valley, CAN6128UJoslyn Larry J · Las Vegas, NVN6129CSumner Scott B · Catoosa, OKN6129HHouk Air LLC · Waverly, OHN6129JBlue Skies Aircraft LLC · Kalispell, MTN6129LDodson David W · Granger, INN612APThomas Lucas G · Beebe, ARN612BKKqm Aviation · Manassas, VAFirst renewal noticeN612BZDerby City Aviation LLC · Vero Beach, FLN612CAOmni Aero LLC · Wilkesboro, NCN612DMRegistered aircraftN612DPCarlson Glenn Alan · Byron Center, MIN612EHIsland Flyers Inc · Addison, TXN612ERNelson James W · Lake Villa, ILN612FTFlorida Institute Of Technology · Melbourne, FLN612GCareer Pilot Training LLC · Wilmington, DEN612GGMid Missouri Spray Service LLC · Richmond, MON612GPPlugge Glen A · Tuscaloosa, ALN612HKDickey Stephen H · De Leon, TXN612HPAmerican Patrols Inc · Midland, TXN612JATextron Aviation Inc · Wichita, KS
Back to AD 81-18-04 R2