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.
N447ARRv 9a Flyers LLC · Lubbock, TXN44844Morland Robert L · Bowman, NDN44845N44845 LLC · Ozark, MON44859Tarcelo Francis Antonio G · Sun City, CAN44862Red Arrow III LLC · Carson City, NVN44889Gray Bradley D · Killeen, TXN44891Rci Asset Management Inc · San Diego, CAN448CDKrebs Stephen P · Houston, TXN44903Treehouse Aviation LLC · Tuscaloosa, ALN44941Herboldsheimer Dixon · Westminster, CON44945Valiair Lc Trustee · Casper, WYN44962Johnson Bud W · Cedar City, UTN44966Gillette Scott A · Lancaster, CAN44968Mil2atp Inc · Pikeville, NCN44995Fenton Flyers LLC · Ellisville, MSN449DWWalt David L · Clarkston, MIFirst renewal noticeN44AEMiloud Chadd K · Fort Worth, TXN44CGBlackwolfden Aviation LLC · Belgrade, MTN44ENN44en Aviation LLC · Holden, MAN44LBCadet Michel · Locust Grove, GAN44LWWilson Lorraine · Richmond, TXN44RKHelmerich Jonathan David Jr · Tulsa, OKN44XPFurnace Joel Ray · Golden, CON4511SConner Gary Dean · Cypress, TXN4514HIndigo Of South Fl Inc · Sunrise, FLN452THHumphrey Andrew D · Johnstown, OHN4537BNewsom William A · Cheraw, SCN453CDGizelbach Anthony · Newnan, GAN454AKClum David V · Anchorage, AKN454BWWheeler Jonathan R · Idaho Falls, IDN454MKSuttle Carl · San Jose, CAN455BZVeetwo Inc · Merritt Island, FLN455WCHayes William F · Perrysburg, OHN4564XMulti-Time LLC · Jacksonville, FLN4567GKris Noone Air LLC · Wilmington, DEN456CRMcevoy Richard D Trustee · Anchorage, AKN456WPrez Carl · San Antonio, TXN4570CFairbanks Investor LLC · Fairbanks, AKN4571CBlair Whitney · Temecula, CAN4574XClassic Air Aviation LLC · Mesa, AZN457LMyers Aviation LLC · Mukilteo, WAN45ADLen Timothy Allen · Deland, FLN45GVRedd Aviation LLC · Springville, UTN45MTTimp Trails Ltd LLC · Orem, UTN45SDEast Hill Seneca LLC · Ithaca, NYN4604TWeitemier Stanley G · Wadena, MNN4607TPbk Aviation LLC · Jefferson, GAN4609TLamoureux Nicholas J · Moab, UTN4612TWeaver Matthew B · Kasilof, AKN4614TOdonnell Daniel V · Dover, DE
Back to AD 81-13-10 R1