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.
N74718Jordan Victor M · Carson City, NVN74719Valerio Lori-Anne · Corona, CAN7471KFunckes William · Zeeland, MIN7471LRegistered aircraftN7471MN7471m LLC · Sheridan, WYN7471RBalderas Jose Aaron Jr · Mission, TXN7471VCollins Ronald Rs · Rutledge, TNN7471WRegistered aircraftN7471YLi Yilin · Alma, MIN74720Woods Donald E · Great Falls, MTN74722Feigitsch Michael · Minot, NDN74723Craige Research Inc · Roslyn Heights, NYN74725Oran 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, ALN74737American Asset Leasing LLC · Aurora, ORN7473DRezzonico John · Round Hill, VAN7473KMachado Douglas M · Kenai, AKN7473RSonntag 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, WA
Back to AD 81-18-04 R2