AD 81-13-10 R1
Registered aircraft · 4,001
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-13-10-R1')
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-13-10-R1')
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-13-10-R1') 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-13-10-R1') 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.
N276NYFogarty Richard · Mandeville, LAN2779MFuist Richard · Lake City, FLN277MHEuroaviation Inc Trustee · KematenN277TAAndersen Thomas E · Pleasant Valley, CTN27CTClinic-Air Aviation · Chapmansboro, TNN27HMMaccarone Mario R · Wasilla, AKN27JAPacific Aviation Management Inc · Fresno, CAN27LPPlane Fun Inc Tr Trustee · Snellville, GAN27WMHeidebrink Ronald E · West Chester, OHN27XDSweetgrass Flyers LLC · James Island, SCN280XMorgan Travis L · Eagle River, AKN2815MEd Hamilton Investments Lc · Richmond, TXN281RMHolthaus Craig J · Canton, ILN2825KHigh Flying Club Inc · Fort Wayne, INN2827NN714dd LLC · Pembroke Pines, FLN2828LInverted LLC · Las Vegas, NVN282XBrekken Chris · Prescott, WIN2835NDelsair Inc · Maitland, FLN2837AGreen Tree Aviation LLC · Provo, UTN2837ELincoln Bruce · Lake Odessa, MIN2839YTurbo Arrow LLC · Fresno, CAN283XMunhall Alan V · Lakeview, ORN2845FRoss Pauline · Aspen, CON2847UFlow Building Solutions LLC · Cartersville, GAN28482Cecchi Jeanne · Oroville, CAN2849SWestex Towers Inc · Abilene, TXN285Crawford Geoffrey E · Cottonwood, CAN28514Diuguid II LLC · Ghent, KYN2854XSmith Richard M · Whitleyville, TNN2855JKing Dennis G · Purcellville, VAN2855MCutler Jeffrey R · Columbus, INN2859ABockholt David W Trustee · Foster City, CAN2859HGarrelts Larry R Trustee · West Yellowstone, MTN286BWCalifornia Falcon Aviation Inc · Anaheim, CAN286XKelly John Thomas III · Bells, TXN2870ARodriguez Rafael Corrales · Miami, FLN2871CTaylor Brandon C · Prosper, TXN2872THenley Brett · Manchester, TNN2878MCamous Alain E · Sunrise, FLN2879CAero Jackson LLC · Bradenton, FLN2879WEvenson Paul S · Grant, MNN2879YDawson Ronald Dwight Sr · Garland, TXN2881MJones James N · Missoula, MTN28966Life Aviation LLC · Winston Salem, NCN28967Flying Farmers LLC · Ogden, IAN28971Cullman Daniel H · Kent, WAN2897TAnderson Eric · Pembroke, MAN28988Wittbrich LLC · Union Grove, WIN28989Buckin 307 Taildraggers LLC · Casper, WYN28BJBj Aviation Inc · Littleton, CO
Back to AD 81-13-10 R1