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.
N922MKNational Aircraft Leasing Corp · Greenville, DEN922PBillester Stephen E M · Parker, CON922PWWilliams Carlton M · Big Lake, AKN922TAAtp Aircraft 4 LLC · Wilmington, DEN922TJBowar Gary R · Miranda, SDN922WSWerth Jill · Canandaigua, NYN92303Herman M Flink Inc · Mount Dora, FLN92306High Wingers Inc · Racine, WIN92307Lowcountry Flight LLC · Johns Island, SCN9230DTbo Enterprises Inc · Chippewa Falls, WIN9230MPernick Kevin · Milford, IAN9230SSlominski Marcus A · Chapin, SCN9230TProctor Richard P · Statesboro, GAN9230VCloud Surfing Aviation LLC · Costa Mesa, CAN9230WLorenti Anthony Charles · Meriden, CTN9230YDhs Operations LLC · Wilmington, DEN92318Flitepro Inc · Murrieta, CAN9231JLeetz Tom · Elgin, ILN9231VShaffer Lawrence · West Des Moines, IAN92324Pea-Wayman Flight LLC · Daytona Beach, FLN9232BLaird Charles L · Adelanto, CAN9232GHarold H Bruner · Pinehurst, IDN9232JAdirondack Flying Club LLC · Rome, NYN9232LLuquette Harley M · Abbeville, LAN9232RRogers Ricky R · Saint Francis, KSN9232TSannella Joseph J · Missoula, MTN9232VFerri Lawrence E · Lake Worth, FLN9232WBarnum Eric E Trustee · Maumee, OHN9233LGreen Samuel B · Clifton Park, NYN9233MSlone Buddie M · Waynesburg, KYN9233RBlash Gregory J · Corona, CAN9233VRenner David C Jr · Belleville, ILN9233WMount Up Aviation LLC · Kirbyville, MON9233ZCalmwinds LLC · Middletown, DEN9234ACruz Salvador A · Sumter, SCN9234ELdg LLC · Kalispell, MTN9234KUnusual Attitudes LLC · Stow, OHN9234MRed Tail Scholarship Foundation · Tuskegee, ALN9234WRutledge Brent E · Uvalde, TXN9234ZIovanna Steven · Plymouth, MAN92356Hub City Aviation Academy LLC · Lubbock, TXN9235CWilliams Patrick S · Saint Paul, MNN9235LKidd Jeffrey A · Norcross, GAN9235QInternational Air Services Inc Trustee · Carson City, NVN9235SKaidor Jerome L · Hayward, CAN9235VLott William F Jr Trustee · Oklahoma City, OKN92362Yeakley Gary G · Ontario, CAN9236CRudloff Uwe K · Lake Village, INN9236EPorch Brock J · Philip, SDN9236HOptic Air LLC · Sioux Center, IA
Back to AD 81-18-04 R2