AD 64-07-05
Registered aircraft · 92
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:64-07-05')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:64-07-05')
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:64-07-05') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:64-07-05') 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.
N1002ZArnold Sarah D · Benton, TNN102KWabash Valley Soaring Association Inc · Lawrenceville, ILN1047ZDyer Evan H · Ann Arbor, MIN10DVStringer Jeffrey H · Niskayuna, NYN10LSLund Clayton L · Cheboygan, MIN1164Benjamin Kirby · Colorado Springs, CON116DSStevenson Malcolm D Jr · Cedar Crest, NMN1196Clayton Harry L · Wichita, KSN1200Carpenter James M · Harrisburg, NCN1287VNorris Eric Brent · Santa Clara, CAN13233Ag Leasing LLC · Wilmington, DEN1342Pfeiffer Neal J · Wichita, KSN166EChesser Richard S · Aiken, SCN170DRReisman William M · Lookout Mountain, TNN1771RLsk Aviation Corp · Wilmington, DEN1825Powell Chuck E · Benton, KSN196PLMidwestern Soaring Assoc · Peculiar, MON221LDutchliar Inc · Wilmington, DEN254CJSouthern Eagles Soaring Inc · Butler, GAN2634PWagenknecht Harald H · Ruther Glen, VAN2720COchsner David W · Clinton Twp, MIN3038KPfeiffer Neal J · Wichita, KSN3075Gradwell Dean H · Jacksonville, ORN3083Leonard Steven E · Wichita, KSN3176Schuur David L · Flat Rock, ILN335SEConnelly William E · Omaha, NEN374TGPeterson Thomas J Jr · Newtown, PAN4007UWabash Valley Soaring Association Inc · Lawrenceville, ILN4029ALeonard Steven E · Wichita, KSN4099CPasquantonio Raymond · Canton, MIN412XLAbercrombie David R · Eatonton, GAN4280AWolfe Donald E · Notasulga, ALN4296CManeely Roy H · Wadsworth, OHN43JHohanshelt Laura S · Minneapolis, MNN458BKClosson Luke E Jr · Valdosta, GAN4600TDevine Steven C · Doylestown, PAN4637TMetz Stephen V · Stanton, MNN4660SChristman Timothy A · Dayton, OHN4663SClayton Harry L · Wichita, KSN4676SHenderson Gary W · Bowdon, GAN4678SMorrison Scott R · Keizer, ORN4700GSouthern Eagles Soring Inc · Butler, GAN4759SSchwartz Louis A · Santa Monica, CAN4784SPort Townsend Aero Museum · Port Townsend, WAN4793TVon Tresckow Peter M · Madison, WIN4938CShockey Jason M · Wharton, TXN5066Markowitz Neal S · Pittsfield, MAN53RAWichita Soaring Assoc · Wichita, KSN5578AFargo Air Museum · Fargo, NDN5597AKolberg Rocky · Kelso, WA
Back to AD 64-07-05