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.
N7041AOfarrell Scott T · Seattle, WAN7041EDykstra Wayne A · Pipestone, MNN7041SMaclean John A · Glenview, ILN70429Petersons Performance Plus Inc · El Dorado, KSN7042AGuilbert Gerald L Jr · Fairfax, VAN7042EBennett Cass · Oxnard, CAN7042FKadlecovic Martin · Prescott, AZN7042SNuernberger Howard P · State College, PAN7042XSale Reported · Larwill, INSale reportedN7043ETri State Airmotive LLC · Berryville, ARN7043SBaughman Jeffrey S · Keller, TXN7043XMile High Flight Club Inc · Miami, FLN70440Moore David · Hernando, MSN70442Knefley J Michael · Ulysses, PAN7044ABradley Shannon C · Carrsville, VAN7044FHanson Mike D · Vinton, IAN7044XKlenoski Brian D · Fulton, MIN7045SDiblasi Francis L · Shelton, CTN7045TDougherty Peter G · Yakima, WAN7046MCrosby Kenneth R · Trapper Creek, AKN70471Berens Eric A · Stevens Point, WIN7047EWhitley Steven · Auke Bay, AKN7047FVanderlei Lowell B · Springfield, SDN7047HKaufman Michael J · Richland Center, WIN7047MAtkins Daniel S · Verona, WIN7047SHaley William R III · Carrollton, GAN7047TPetersen Derrick D · Sibley, IAN70484Fairfield George Edward · Solon Springs, WIN7048EHarrison Donald R · Lake Havasu City, AZN7048THenegar Robert A · Newhope, ARFirst renewal noticeN7048XGartner Thomas M · Newton, KSN7049ATjernjund Wesley Gordon · Salem, ORN7049MBarnett Ruben · Bardstown, KYN704AAWasatch Industries LLC · Ogden, UTN704ACRegistered aircraftN704AEYocom Jason D · Cocoa, FLN704AHN704ah LLC · Darien, WIN704ASAuger Allan D · Conifer, CON704ATLongnecker Michael · Stuttgart, ARFirst renewal noticeN704AULosey Rodric O · Nipomo, CAN704AWKroeger Dean · Two Rivers, WIN704AYAndreasen Mark D · Ridgefield, WAN704AZFrantz Dean A · Adrian, MIN704BEGore Cleveland · Manning, SCN704BFEmporia Flying Club Inc · Emporia, KSN704BGJones Kermit L III · Jasper, ALN704BHCloud Buddies LLC · Charlotte, NCN704BMEdwards Richard V · Acampo, CAN704BZFranks John W · Barberton, OHN704CACircle S Aviation LLC · Starkville, MS
Back to AD 94-05-05 R1