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.
N75871Blue Wing Flyer LLC · Marietta, GAN75874Walled Lake Flying Club · Waterford, MIN75876Roe Amber · Scotts Valley, CAN75878Milosevich Nikola · Deland, FLN75879Griffin Aviation LLC · Spokane, WAN7587EBroderick William E · Sterling, MAN7587JLaney Ricky Allen Jr · New London, NCN7587RFca Flight Training LLC · Washington C H, OHN7587VBradley Vaylan L · Keller, TXN7587WHawbaker Ray · Quinter, KSN75884A-Z Aviation LLC · Bay City, MIN75885Mds Enterprises LLC · Lemont Furnace, PAN7588CGrand Aviation Inc · Grove, OKN7588EGross Barbara J · Timber Lake, SDN7588FWilbanks Kari L · North Port, FLN7588HEagy Gregory L · Boise, IDN7588PMyres Ronald W Trustee · Mckinney, TXN7588WRustic Getaways LLC · Eagar, AZN7588YK&Cs Saveacomanche LLC · Spring Lake Park, MNN75890Milligan Tony L · Rumford, MEN75897Gopalakrishnan Sanjeev K · Spring, TXN75898Center O Flying Club · Tumwater, WAN7589DBergstrom Aircraft Inc · Pasco, WAN7589FAerial Advertising Services · Livermore, CAN7589VCorwin Lloyd D · Idaho Falls, IDN758CPCivil Air Patrol · Maxwell Afb, ALN758PANew Horizons Aviation Inc · Goshen, INN758RBde Aviation Services LLC · Chatham, ILN758YSFly Sky Ads LLC · Manalapan, NJN758YTMountain Air Flying LLC · Brigham City, UTN75904Worley Dan L · Heber Springs, ARN75907Rmb Leasing Inc · Dover, DEN75909Martin Michael J · Anchorage, AKN7590JOhlman Matthew · Atlanta, GAN7590KByers Steven J · San Diego, CAN75917Abs Aviation · Lanham, MDN7591EYoung Carl J · Lubbock, TXN7591FFinger Lakes Soaring Club Inc · Dansville, NYFirst renewal noticeN7591GRochez Gerald A · Jensen Beach, FLN7591RRight Rudder Brothers LLC · East Point, GAN7591VHallack Daniel Edwin · Hart, MIN7591WBurin John · Durango, CON75922Phillips Lester L · Pahrump, NVN75925A&A Aviation LLC · Edinburgh, INN75926Owens Flight Training LLC · Lafayette, LAN7592HClaypool Kimberly A · Ottumwa, IAN7592JWalker David C · Elk City, OKN7592PStrobach Kristin K · Rib Lake, WIN7592RInternational Security Network Inc · Pahrump, NVN7592VMisener Richard H · Hermiston, OR
Back to AD 81-18-04 R2