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.
N840CDWeston Flyers Inc Trustee · Wilmington, DEN8412BPlane Fun Inc Tr Trustee · Snellville, GAN8413NFronek Brice A · Lake Havasu City, AZN8413TDmh Aviation LLC · Rochester, MIN8417AGate 13 LLC · Santa Fe, NMN8417HWalser Air LLC · Warwick, RIN841BMescalero Aviation LLC · San Antonio, TXN8423HSale Reported · Greeley, COSale reportedN8423MBrown Rodney E · Nixa, MON8426GWisconsin Aviation Inc · Watertown, WIN842TSAerospace Trust Management LLC Trustee · Wilmington, DEN8432HBt-Gs Aviation LLC · Baytown, TXN8434MHenning George C Jr · Westlake, OHN8437GAnthem Commercial Air Services Inc · Jacksonville, FLN8437NMattessich Martin J · Woodbridge, CTN8437UCavu Aviation LLC · Glenmont, NYN8437YCool Air Investments LLC · Mission Hills, KSN8439ARuegger Pamela A · Beloit, WIN8443LM & M Aviation Services Ltd · Rock Falls, ILN8446BBas Part Sales LLC · Greeley, CON8446CKnierim John J · Puyallup, WAN8448CWoodburn Brian · Glenpool, OKN8449HDelaware Aircraft Trust LLC Trustee · New Castle, DEN8449LMichaels Wings LLC · Parker, CON8455ZD&J Aviation LLC · Apopka, FLN8456CAmblygon Ltd Co · Boise, IDN8456HWings Of Hope Inc · Chesterfield, MON845BWOcean Palms Aviation LLC · Hudson, FLN8460ASpurgeon William E Trustee · Edmond, OKN8461HTwin Seneca 8461h LLC · Lewes, DEN8463PSams J Mark · Franklin, OHN8464PPerma-Cal Leasing Inc · Minden, NVN8468JKrantz John · Springfield, TNN846JWPrater Keith · Blaine, WAN847BKKornoely Burt R · Cragford, ALN8487FFuhr David · Wabasso, MNN8489FRegistration Pending · San Diego, CARegistration pendingN84CWestern Summit Enterprises Inc · Pacoima, CAFirst renewal noticeN84EBas Part Sales LLC · Greeley, CON84LCRegistered aircraftN84MABrown Michael R · Fort Gibson, OKN84MRFreeland Robert S · Knoxville, TNN850PIftikhar Naveed · Tempe, AZN8510FSkyline Utilities Inc · Brainerd, MNN8514CSpirit Air Inc · Salmon, IDN853BTParadigm Aviation LLC · Sioux Falls, SDN853LBChicago Aviation Services LLC · West Chicago, ILN8547FPage Elton T III · Cotulla, TXN854JWG&D Holdings LLC · Provo, UTN8558CDan & Jerrys Greenhouse LLC · Monticello, MN
Back to AD 81-13-10 R1