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.
N8573XSale Reported · North Royalton, OHSale reportedN8574CVan Wagner Aerial Media LLC · Hollywood, FLN8574KSkyborne Airline Academy Inc · Vero Beach, FLN8575BMilam Michael S · Robinson, TXN8575VMcintyre Jon D · Fairbanks, AKN8575WSkyborne Airline Academy Inc · Vero Beach, FLN8576CReser Byron G · Walla Walla, WAN8576VJam Three LLC · St George, UTN8576WHaynes Edward · Snohomish, WAN8576XSkyborne Airline Academy Inc · Vero Beach, FLN8576YCenterline Holdings LLC · Belgrade, MTN8577Burke Jeremy D · Westminster, CON8577CWaldmiller Robert Joseph · Rosamond, CAN8577VHoran Spraying LLC · Plainview, TXN8577WM97west LLC · Fargo, NDN8577YSkyborne Airline Academy Inc · Vero Beach, FLN8578Ray Christopher Kevin · Wake Forest, NCN8578CRiver Valley Flyers LLC · West Hartford, CTN8578DCoy Shane A · Nenana, AKN8578EDamrow L Bruce · Jay Em, WYN8578VNelson Timothy E · Fairbanks, AKN8578ZSkyborne Airline Academy Inc · Vero Beach, FLN8579Ralls Eddie · Evergreen, ALN8579CSolberg John W · Bismarck, NDN8579NWillaero LLC · Union City, TNN8579PWor LLC · Jamaica Beach, TXN8579VWalsh Leo A Jr · Anchorage, AKN8579WWessler George H · Dunedin, FLN857ACToedtli Bryan S · Vancouver, WAN857AKOld City Helicopter Sales LLC · St Augustine, FLN857AUAuburn University · Auburn, ALN857DKKnight Kevin · Dallas, TXN857ERAlpha International Aircraft Inc · Lewes, DEN857GArcher Flight LLC · Wilmington, DEN857JWWarren Joseph A · Milford, DEN857MMVigilante Helicopters LLC · Lewistown, MTN857NTSmeltz Kent · Dornsife, PAN857PDFelter John Vincent Jr · Lago Vista, TXFirst renewal noticeN857RDUniversity Of North Dakota · Grand Forks, NDN857SSjs Aviation Co · Casper, WYN857SCFf22 LLC · Scottsdale, AZN857SPSoutheastern Oklahoma State University · Durant, OKN8580DKedrowski James L · Wasilla, AKN8580ESkyborne Airline Academy Inc · Vero Beach, FLN8580NA1 Aviation LLC · Lewis, DEN8581ASkyborne Airline Academy Inc · Vero Beach, FLN8581DDutch Air LLC · Kalispell, MTN8581JSkyborne Airline Academy Inc · Vero Beach, FLN8581VObx Airplanes LLC · Manteo, NCN8582CCurran Aviation Services LLC · Yorba Linda, CA
Back to AD 81-18-04 R2