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.
N93WVRose William A · Milton, WVN93WYRush Aviation LLC · Hayden, IDN94000Champion Aircraft LLC · Valdosta, GAN94006Leading Edge Aviation Inc · Doylestown, PAFirst renewal noticeN9400EVan Anda Aviation LLC · Apopka, FLN9400HRoach John C · Lawrenceburg, KYN9400JRobinson William L · Buckeye, AZN9400KSyvanen Janne M · Staten Island, NYN9400LMerino Cesar · Washington, DCN9400WLow Wing Aviation LLC · Mountain Home, ARN9401CRegistered aircraftN9401DBenesh Stephen P · Oshkosh, WIN9401HConstantine Costas T · Newington, CTN9401LAustin Aviators Flight Club · Austin, TXN9401NJanes Charles Dale · Cleburne, TXN9401PGranite Aviation LLC · Belgrade, MTN9402DH C E Leasing LLC · Cleveland, TNN9402JHigh Flight Flying Club LLC · Reston, VAN9402KCash Management Consulting LLC · Granite Springs, NYN9402LMacgillivray Ian Spencer · Bakersfield, CAN9403DKlingenberg Tim C · Udall, KSN9403LZachary Taylor M · Queen City, TXN9403VSwift Damian · Livermore, CAN9404FBas Part Sales LLC · Greeley, CON9404HSowell Richard G · San Jose, CAN9404JCordice Jearohan Giles · Fort Worth, TXN9404KJmy Aviation LLC · Merritt Island, FLN9404LPeak 8 Aviation LLC · Breckenridge, CON9404N9404n LLC · Brush Prairie, WAN9405JSky Blue Horizon Aviation LLC · Gainesville, GAN9405LVann Dudley C · Greenville, NCN9405PDoyle Kevin M · Kenai, AKN9405VShoop Robert A Jr · Austin, TXN9406DMartin James D Sr · Coeur D Alene, IDN9406JNorth County Flight Training Inc · Carlsbad, CAN9406PHager Jerome P Jr · Frazee, MNN9406VKuyami Inc · Las Vegas, NVN9407DMatthew P R Mcdaniel · Oak Creek, WIN9407HB2w Corporation · Winona, MNN9407KCollebrusco Robert L · Springfield, ILN9407LBowling David L · Indianapolis, INN9407VWarkentin Lynden K · Russell Springs, KYN9407WLozes Jay P · Covington, LAN9408LMccallum David DBA · Napa, CAN9408NCope Parrish B · Lemoore, CAN94097Registration Pending · St Simons Island, GARegistration pendingN9409CN9409c LLC · Phillipsburg, KSN9409GGlenn Roy J · Shelbyville, TNN9409LLaguna Verde Leasing Inc · Wilmington, DEN9409WMoffett Richard · North Las Vegas, NV
Back to AD 81-18-04 R2