AD 87-10-06 R1
Registered aircraft · 72,010
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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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.
N7133LHutchins Perry L · Little Rock, ARN7133QPage Aerial Service Inc · Rochelle, ILN7133VKing Mitchell Earl · Columbus, MSN7133WSale Reported · Tomahawk, WISale reported, pending cancellationN7134BSchmittle Michael D · Yermo, CAN7134CUS Flight Academy International Inc · Post, TXN7134DSprenger Mark R · Eagle River, AKN7134LCook'S Aviation LLC · Conover, NCN7134PHayduk International LLC · Rockhill Furnace, PAN7134REney Brian P · Malibu, CAN7134UDalton James D · Pasadena, TXN7134WHolley Donald W · Willis, TXFirst renewal noticeN7135BHillegeist Tracy L · Beverly, KSN7135JSierra Flite LLC · Camden, DEN7135MFitts Darrell Jr · Greenbrier, ARN7135QHoman Larry E · Sigourney, IAN7135RDavey Spencer J · Spokane, WAN7135VHerkoltz Patrick Alan · Phelan, CAN7135WBudzak Gary M · Naperville, ILN7136LSchulte Barry M · Union, NJN7136QPa Lawrence LLC · Anchorage, AKN7136VHickman Jared · Bothell, WAN7136XArchangel Michael Flyers Inc · Princeville, HIN7136YSchilling Stephen V · Rockford, ILN7137LSlinkard Andrew L · Mesa, WAN7137UMalone David V · Oklahoma City, OKN7137VZelek Daniel · Wurtsboro, NYN7137WGoegebuer Brent L · Corona, CAFirst renewal noticeN7138BJlg3 LLC · Wentworth, SDN7138CDe Aviation LLC · South Wayne, WIN7138DFiebig Joel · Sebewaing, MIN7138PHickman Marcus · Fort Worth, TXN7138RFleahman Colton · Woodlawn, TNN7138UHinkle Robert J · Caldwell, IDN7138VColombo Brian M · Oswego, NYN7138WBazal Jared · Castle Rock, CON7139CGv Air Inc · Medford, ORN7139GSkysg LLC · Eugene, ORN7139KCool Tail Draggers LLC · Red Oak, IAN7139LAmoss Harold Lindsay III · Redmond, ORN7139PPendlay Heath V · Kalispell, MTN7139QFernander David · Enterprise, ALN7139TPhilpot John Michael · Liberty, MON7139UMott Charles A Jr · Chesapeake, VAN7139WWindover Wings LLC · Lancaster, PAN7139XBryk Steven L · Port Orange, FLN713BDTate Ed N · Sheridan, ORN713BMMathieu Robert B · Delhi, LAN713CGDarrow John Kenneth · Soldotna, AKN713DBBourgoin Dale R Trustee · Saco, ME
Back to AD 87-10-06 R1