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.
N7026DSfcaa LLC · Nashville, TNN7026KBryant Stephen C · Anchorage, AKN7026MLoerzel Loren · Blair, NEN7026RSanderson Eric R · Chelan, WAN7026UWilliams Mike C · Sonora, TXN7026WAdvanced Aviation Inc · Lakeville, MNN70275Christiansen Aviation LLC · Wilmington, DEN7027DHuriburt Ward · Dillingham, AKN7027KMorrison James II · Grandview, TXN7027QAero B Flying Service · Richards, MON7027UTtwn Media Networks LLC · New York, NYN7027VJohnson Marvin D · Gilbert, AZN70282Edwards Robert J · St Helena, CAN7028GKathol Donavin J · Hartington, NEN7028PNorthern Cape Sea Farms LLC · Cape May, NJN7028QBurns Michael S · Coplay, PAN7028RCuckler Jason Michael · Jenks, OKN7028WBlakely Richard S · Yerington, NVN7028YAces High Aviation Corp · Pembroke Pines, FLN7028ZQuality Aviation Inc · Marana, AZN7029BAir Ex LLC · Chelan, WAN7029KWillmeroth Wilbur D · Deland, FLN7029RBazzi Adel · Yorba Linda, CAN7029WUSA Aircraft Leasing LLC · Dover, DEN702AWBrown Pryce R · Anchorage, AKN702BSTwo Bravo Sierra LLC · Auburn, CAN702CCRpd Enterprises Inc · Nicholson, PAN702CPCivil Air Patrol · Maxwell Afb, ALN702DBShiffer David A · Woodstock, OHN702DCTaylor Denise DBA · Lincoln, CAN702ELAerostar Transportation Systems LLC · Houston, TXN702GTsiouklas Aviation Inc · Dunedin, FLN702GPUniversal Investors LLC · Independence Chate, MIN702GRAir America Flight Center LLC · Daytona Beach, FLN702JWisdom Murrel Wade · Nashville, ARN702LULiberty University · Lynchburg, VAN702NVAca Sd LLC · Kalispell, MTN702RASmtm Holdings Inc · Wilmington, DEN702RVWhipple Bruce F · Rockford, MIN702SBSierra Bravo Partnership · Liberal, KSN702SPSportsmans Market Inc · Batavia, OHN702TBGoshen Shmuel · San Carlos, CAN702TKWells Lance L · Hanksville, UTN702XLeonard Steven E · Wichita, KSN7030JTtwn Media Networks LLC · New York, NYN7030PMartens And Wyatt Air Service LLC · North Platte, NEN7030RAlpha Kilo Aviation LLC · Wasilla, AKN7031ASmith Helicopters Inc · Cotulla, TXN7031BMason Crosby H · Zebulon, NCN7031CWestern New York Flying Club Inc · Bowmansville, NY
Back to AD 81-18-04 R2