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.
N76847Sharkey John P · Saint Charles, MON76848Lott Dennis Paul II · Clinton, MSN76850Rawls Steve · Fernandina Beach, FLN76861Kaufman Rodney G · Silverton, ORN76865Eagles Wings Inc · San Angelo, TXN76867Prato Joseph H · Livonia, NYN76868Sanders Brittany M · Bakersfield, CAN7686EChristie Ian A H · Limon, CON76871Gaipa Tim · Saint Joseph, MIN76874Olsen Jerry K · Rosamond, CAN76875Richard Brady K · Farmers Branch, TXN7687DAndreas Nicholas · Bemidji, MNN7687XMost Ronald · Apple Valley, CAN76882Williams Jason R · Troy, OHN76883Cox Keith L · Griffin, GAN76885Delta Ridge Farms LLC · Oak Grove, LAN76887Victor Whiskey Aviation LLC · Spring Branch, TXN7688TRodgers Bruce W · Pine Bluff, ARN7688XMauldin Gary · Navajo Dam, NMN76893Wright Joseph G · Medicine Lodge, KSN76894Sislo James W · Wausau, WIN7689MMoreland Wesley · Mckinney, TXN7689TMcclatchey Steven C · Linn Grove, IAN76903Jones David L · Powderly, TXN76905Guidice Donald C · Chugwater, WYN7690GScott Kyle J · Fort Morgan, CON7690TFranwick Industries LLC · Westbrook, CTN7690XNeu Aviation LLC · Benton, LAN76915M R G 2 LLC · Galesburg, ILN7691MKoch Doug L · Wentworth, SDN7691TDewitt Dennis M · Collinsville, ALN7691XAndrade Nelson J · Redwood City, CAN76925Hamman Baron L · Dallas, TXN76926Rachael Earl · Keene, NHN7692EBrickwood-Figgins David B · Tulsa, OKN7692MMeyer Lynn O · Olathe, KSN7692UDaso Manuel Sebastian · Spring Hill, FLN7692XJohnson Kevin D · Eldorado, KSN76930Osowski Wes · Kodiak, AKN76932Lowe David M · Sacramento, KYN76933Almaguer Carlos · Mcallen, TXN76937Thaxton Douglas C · Chandler, AZN7693EBrignac Flying Service LLC · Columbus, MSN7693TButler Richard A · Gatesville, TXFirst renewal noticeN7693UPerkins Robert A · New Richmond, WIN76942Hawkins Brennan J · Superior, WIN76944Fachko Michael J Jr · Grand Island, NYN76946Mayton Travis W · Decatur, TNN76948Martin Gerard A · Boston, KYN7694EWilliams Lisa Goulet · Summerland Key, FL
Back to AD 94-05-05 R1