AD 94-20-04 R2
Registered aircraft · 4,469
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-20-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:94-20-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:94-20-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:94-20-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.
N28LDDancing Bear LLC · Polson, MTN28SGMarshall Robert W · Hemet, CAN28WBMulder Air Inc · Renville, MNN2904BPricer J Richard · Arlington, TXN2907BPowell Gregory S · Paso Robles, CAN2910BShively Aurora J · Anchorage, AKN2917BPyle Dana · Naples, FLN291ABSerafini Louis · Ringwood, NJN2921BMurray Michael E · Fallbrook, CAN2924BBonanza N2924b LLC · Hermann, MON2929BRegistered aircraftN2930BMcdougall Angus D · Gillette, WYN2931BMake It So LLC · Knoxville, TNN2942BThomas Ronald G · Dallas, TXN2944BVantreese Kenneth C · Tulsa, OKN2949BKlassen Lloyd G · Enid, OKN2950BReichert Thomas W · Dickinson, NDN2952BReardon Michael · East Falmouth, MAN2954BO'Conell David DBA · Butte, MTN2960FNaber Tania B · Niceville, FLN2962BBridges Janiece · Forsyth, MON2969BBlaszak Benjamin D · Troy, MIN2970BRymer Joseph M · Riverview, FLN2971BParker Michael T Trustee · Denton, TXN2972BTowle Karl E · Denton, TXN2973BLightle Theodore L · Cocoa, FLN2975BHayes Jack D · Kingman, AZN2976BParker Michael T Trustee · Denton, TXN2977BFilippelli Kenneth J · Edmond, OKN2978BDelarosa Kelly · Port Orange, FLN2980AWest David R · Newalla, OKN2981BStowells Outlaw Services LLC · Rigby, IDN2983BFisher Bryce Anthony · Cleveland, TNN2986BBrittian Scott A · Wichita, KSN2993BHillegeist Tracy · Beverly, KSN2995BLeggat Douglas J · Manhattan, KSN2996BSale Reported · Alton, ILSale reportedN2997BFigueroa Christopher · West Covina, CAN2999BNordhagen Melvin L · Spokane, WAN29DCDwlg Aviation LLC · Rogers, ARN29VRegistered aircraftN2CBBoxman LLC · Wilmington, DEN2CSBolton Geoffrey M · Groveland, CAN2DCGottsleben John J · Tucson, AZN2DNHaines Matthew E · Lake Dallas, TXN2DRGustafson Dale H · Kingwood, TXN2DURegistered aircraftN2EYBender Jeffrey T · Scottsdale, AZN2GRRichardson Gordon B II · Caldwell, TXN2JXBrookeash Inc · Waxahachie, TX
Back to AD 94-20-04 R2