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.
N74725Oran Jamie A · Apple Valley, CAN74729Registration Pending · Weston, IDRegistration pending, pending cancellationN7472RSouthern Jeffrey · Rayville, LAN7472WTait Ronald M · Fort Worth, TXN74730Twin Rivers Wildlife Inc · Elko, NVN74731Registration Pending · Bella Vista, ARRegistration pendingN74733Maxwell Stephen R · Dodge City, KSN74735Tipton Michael · Florissant, CON74736Russell Robert C · Decatur, ALN7473DRezzonico John · Round Hill, VAN7473RSonntag Donald · Marengo, ILFirst renewal noticeN7473YSale Reported · Palmer, AKSale reportedN74740Woodyatt Michael A · Byron, ILN74745Renfroe Daniel P · Eagleville, TNN74747Dubois Alan P · Jamestown, RIN74748Moore David · Amarillo, TXN7474DRogue Aero LLC · Grants Pass, ORN7474GBarnett Kevin · Simi Valley, CAN7474JHorton James D · Las Vegas, NVN7474LNelson Travis E · Richland, MTN7474RGregorski Thomas E · Kenly, NCN7474TWorks James K · Avalon, CAN7474WZimmerman Sandra · Henderson, NVN74750Anderson Jonathan R · Corpus Christi, TXN74752Brundige Mark S · Mount Pleasant, TXN74758Robins Stephen B · Hutchinson Island, FLN74759Page Casey P · Abilene, TXN7475RTolsma Garrett J · Kirkland, WAN7475YOverseas Aviaton Inc · Wilmington, DEN74760Boyle Fred Sr · Cape May, NJN74762Bulldog Aviation LLC · Kalispell, MTN74763Crouse Stanley G · Greenwood, MON74764Carter Dejuan Jermaine · Little Rock, ARN74765Lister Thomas L · Wynnewood, OKN74766Reiner Henry A · Hutchinson, MNN74767Emerald City Aircraft Leasing Inc · Port Orchard, WAN74768Delissa Leighton A · Meade, KSN74769Bulut LLC · Los Angeles, CAN7476DHincke Cedar F · Kalispell, MTN7476JHernandez Miguel A · Brownsville, TXN7476LGrabofsky Livestock & Grain Inc · Hogeland, MTN7476RCarrillo Jeremiah · Shelton, WAN7476WAddison Robert M · Fort Sumner, NMN7476YWilliam L Stewart Code Supplies Inc · Rossville, TNN7477Lochinger Dale · Everson, PAN74770Dubois Aviation Inc · Chino, CAN74774Alyeska Helicopters LLC · Girdwood, AKN74775Morriss Robert W · Amarillo, TXN74777N74777 LLC · Key West, FLN7477LWika Gregory B · Anchorage, AK
Back to AD 87-10-06 R1