AD 97-01-13
Registered aircraft · 54,837
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:97-01-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-01-13')
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:97-01-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-01-13') 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.
N3340UGingerich Fred D · Heron, MTN3340YMckinney Sandra C · Williamsburg, OHN3341DTwenty One Miles LLC · Woodland Hills, CAN3341FLani Lea Sky Tours LLC · Honolulu, HIN3341RKozlenko Roman · Irvine, CAN3341TWatson Dennis R · Fort Worth, TXN3341UKroschel Wayne Addie · Mora, MNN3341VAreeckal Rejee · Mcallen, TXN3342FKaradza Bosko S · Welch, MNN3342URobert Smith Associates Inc · Albany, NYN3343FLutes Ralph E · Shipshewana, INN3343JAndresen Paul S · Chandler, AZN3343TMcclellan Dabney B · Centerburg, OHN3343VVitale Paul P · Green Valley, AZN3344JSaitto Jeffrey M · Media, PAN3344RStorm Water Services Inc · Redmond, ORN3344UPiescinski Kurt G · Fort Lauderdale, FLN3345FBrassard Alan Gaston · Durham, NCN3345RJennings Mamie M · Springfield, ILN3345SSummit Foundry Systems Inc · Fort Wayne, INN3345TJefts Donald R · Scotia, NYN3346EEarnst Kelly S · West Lafayette, INN3346LHarper Matthew Clay · Anchorage, AKN3346RGonzalez Oscar · Bedford, TXN3346YVantrease Jerold L · Homer, AKN3347FPrescott Aircraft & Automotive LLC · Prescott Valley, AZN3347LAcumen Aerotech LLC · Rogers, TXN3347SArmitage Justin Marc · Hugoton, KSN3347YMccoy Mark B · Honea Path, SCN3348UCollins Christopher E · Bluford, ILN3348YBlue Sky Flyers Inc · Punta Gorda, FLN3349CCabrera John F · Glendale, CAN3349DWeninger Gregory M · Burrton, KSN3349FMaxfield David · Greenville, SCN3349JRegistration Pending · Quincy, OHRegistration pendingN3349SJin Jin Aviation LLC · Anchorage, AKN334NCarter-Muthana Aero LLC · Bakersfield, CAN334SCGist Sally R · Horseshoe Bay, TXN334WCenturion Investments Inc DBA · Chesterfield, MON334YWarner Aric D · Rosamond, CAN33503Sueltenfuss Tyler G · Boerne, TXN3350FStrait Daniel · Sierra Vista, AZN3350SBarry Jason J · Orange, CAN3350UKragseth Kyle A · Shoshone, IDN33512Kennedy John D · Clinton Twp, MIN3351LGagnon Philip F · Anchorage, AKN3351STarantino Nicholas T Jr · Union City, CAN3351TTaylor Gail L · Red Bluff, CAN3352FDaradici Jodi A · Gilbert, AZN3353TDwinell Jeffrey C · Granby, MA
Back to AD 97-01-13