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.
N6092WBoling Bret J · Wichita, KSN60938Thomas Michael F · Glennallen, AKN6093JAir S & T LLC · San Juan Capo, CAFirst renewal noticeN6093WLee Richard L · Bowie, TXN6094DVan Wagner Aerial Media LLC · Hollywood, FLN6094FBuiqui Aerospace Corp · Kissimmee, FLN6094NAmerican Aviator LLC · Arlington, TXN6094QRakes Bobby N Jr · Saint Robert, MON6094RBoston Executive Helicopters LLC · Norwood, MAN6095SAri Ben Aviator Inc · Fort Pierce, FLN6095ZCoolidge St LLC · Prescott, AZN60963Ncommand LLC · Carencro, LAN6096FColeman Gregory M · Chewelah, WAN6096LC&C Airlines LLC · Mesa, AZN6096XBergman James H · Buckley, WAN6096ZYoung Collin H · Spring, TXN6097FAmeriflyers Of Texas Inc · Addison, TXN6097GSargester Aviation LLC · Middletown, DEN6097LPetrovich Michael · Simpsonville, SCN6097MPea-Wayman Flight LLC · Daytona Beach, FLN6097PGuest Aviation LLC · Crane Hill, ALN6097WWallette Robert Michael · Port Saint Lucie, FLN6098DShurtleff Russell D · Tunkhannock, PAN6098FAmeriflyers Of Texas Inc · Addison, TXN6098LGrosvenor Robert I · Belle, MON6098MAnderson Luther B Jr · Wasilla, AKN6098NRegistered aircraftN6098WFall Line Aviation LLC · Augusta, GAN6099QBas Part Sales LLC · Greeley, CON6099VAerial Sign In · Melbourne, FLN6099XStar Larry D · Gold Hill, NCN609DCBarber Aircraft LLC · Topping, VAN609DJDelta Juliet Holco I LLC · Ocoee, FLN609FAStratus Air LLC · New Castle, DEN609FJMustang Sally Aviation LLC · Camden, SCN609FTFlorida Institute Of Technology · Melbourne, FLN609HZRegistered aircraftN609NRoussopoulos Gary L · Santa Cruz, CAN609SCFf22 LLC · Scottsdale, AZN609SDJones Scott D · Milwaukee, WIN60ACHaas Brent R · Willcox, AZN60AHAngelina Aviation LLC · Lufkin, TXN60ATOconnor Lloyd T · Dillingham, AKN60BLonghorn Leasing LLC · Anchorage, AKN60BEGunn Glenn R · Clearwater, FLN60BZNxbz Aircraft Holdings LLC · Broussard, LAN60CESmith Matthew J · Louisville, KYN60CSAir Flight Enterprises Inc · South Daytona, FLN60DCCmsjet Sales LLC · Union Lake, MIN60DVDelta Victor LLC · Plano, TX
Back to AD 81-18-04 R2