AD 94-05-05 R1
Registered aircraft · 26,232
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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.
N721JMWalton Frederick W · Upper Sandusky, OHN721MWelch James D · Holdenville, OKN72200Hohl Levi M · Kenai, AKN72201Hill Shawn A · Eloy, AZFirst renewal noticeN72202Mccarthy Pamela C · Murphys, CAFirst renewal noticeN72203Valiair Limited Co Trustee · Casper, WYN72208Anderman Melvin E · Greenville, FLN72209Ness Bernie M · New Port Richey, FLN72216Selk Gary B · Eau Claire, WIN7221MStartin Evan A · Colfax, WAN7221TDahle Neil E · Mason City, IAN72220Moyer Michael E · Duarte, CAN72221Severson Robert T · Edmonds, WAN72227Ory Vincent P · Homer, LAN7222AChamberlain C Douglas · Bellefontaine, OHN7222TRegistration Pending · Lawndale, CARegistration pendingN72230Guillory Marshall C · Fayetteville, NCN72234Moser Jerald Lebeau · Tucson, AZN72237Registration Pending · Corona, CARegistration pendingN7223ASather Evan · Hayward, CAN7223GLaze Daniel · Carson City, MIN7223MMoosehead Enterprises LLC · Estero, FLN7223SSong David D · Ashland, CAN7223TRoberts Michael R · Plano, TXN72240Playter Gabe G · Greenville, MIN72245Madland Patrick S · Anchorage, AKN72248Mulhearn Walter Ftrustee · Conroe, TXN72254Leupp John R · Taylors, SCN72255Registered aircraftN72256Cober Jason M · Johns Island, SCN7225AFouts Philip W · Caldwell, IDN7225SAero States Aviation LLC · Owasso, OKN72261Brabec Eric M · Little Rock, ARN72262Schmelzer Richard R · Anoka, MNN7226SN46132 Leasing LLC · Kalispell, MTN7226TCreasman Zane V · Arden, NCN72270Dade Garry A · Nevada, MON72272Glidepath Aviation LLC · Sheridan, WYN72273Triplett B A · Hope, RIN72278Mott Robert H · Yaphank, NYN7227ANewman Christan C · Niota, TNN7227MRegistration Pending · Billings, MTRegistration pending, canceledN72284Machado Mark A · Grass Valley, CAN72287Adams Aviation Services Inc · Peyton, CON7228APaine Jered J · Cashmere, WAFirst renewal noticeN7228MBarton Chris · Bedford, WYN7228SMendoza William S · Antioch, CAN7228XBrown Richard D · Woodward, OKN72292Juel Paul J · Scobey, MTN72296Bennee Shane R · Bluffdale, UT
Back to AD 94-05-05 R1