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.
N8664YWard Nelson Harley · Salcha, AKN86651Wilbur Andrew E · Boyd, WIN86654Dillard Ronald G · Lebanon, TNN8665CBlack Butch · Lakeside, NEN8665FJack Raven · Elk Mound, WIN8665POhayon Eli · San Diego, CAN8665VMaisel Chad L · Plano, TXN8665YRebelair LLC · Stevens Point, WIN8666KBuce Thomas M · Kimberly, ORN8666YZimmermann Aviation LLC · Lake Worth Beach, FLN8667CWaldrops Auto Parts Inc · Taft, CAN8667VBloomquist Ronald D · Mooresburg, TNN8667YCurran Michael · Gallatin, TNN8668Freppon Farm Equipment LLC · Wilmington, DEN86682Twardokens Eva M · Aptos, CAN8668YBennett Karl M · Wellington, FLN8669CB R S Leasing Inc · Wilmington, DEN8669YThermo-Tech Air LLC · Keyser, WVN866ATCxk1 LLC · Wilmington, DEN866AVPiper Aircraft Inc · Vero Beach, FLN866BRBoatright Leslie J · Titusville, FLN866CPCivil Air Patrol · Maxwell Afb, ALN866CTThrash Scott H · Hesston, KSN866FSKostelnik Edward A Jr · Comfort, TXN866JAMcphillips Flying Service Inc · Beaver Island, MIN866MAGoose Aviation Co · Wilmington, DEN866MMMorris Engineering Group LLC · Juneau, AKN866PUTrustees Of Purdue University · West Lafayette, INN866RHMerrill D J · Topsham, MEN866RPShelton Greg N · Collinsville, OKN866SRLouisville Helicopter LLC · Anchorage, KYN866TSSteier Tim A · Blue Earth, MNN866TTSgw Aviation LLC · Hastings, MIN866WKMeyer Benjamin R · Glenburn, MEN8670CReabe Damon P · Ripon, WIN8670EMarvin Carlton R · Tomahawk, WIN8670LSimmons Aviation Services LLC · Pawcatuck, CTN8670YTerpin Gregory A · Champion, PAN86711Crane David D · Cadott, WIN86713Tuckerman Flying Service Inc · Tuckerman, ARN86714Odonnell Daniel V · Dover, DEN86715Yellerhammer LLC · Warner Robins, GAN8671WHooten Joshua C · Heber Springs, ARN86726Sale Reported · Mesa, AZSale reportedN86727Murray Eric J · Kamas, UTN8672DPlate Ronald L · Soldotna, AKN8672EMock Joseph R · Huntsville, TXN8672VHarris Kenneth L · Greeley, CON86738Myran Kenneth · Taylor, NDN8673LKnutson Wayne R · Tioga, ND
Back to AD 81-18-04 R2