AD 94-05-05 R1
Registered aircraft · 26,231
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.
N2373BWarbird Adventures Inc · Ocoee, FLN2373NMorris Gray S · Chugiak, AKN2373UBeeline Aviation LLC · Austin, TXN2374BBoard David N · Moundsville, WVN2374NAutoair Research Inc · Wilmington, DEN2374UEstes Kenneth · Benton, KSN2374VMelveney Aaron · West, TXN2375DGauntt Chep · Goodyear, AZN2375KPowell Larry C · Fresno, CAN2375NLanducci Lou L · Brookshire, TXN2376NDavis Herbert W · Danville, ARN2376UHowell Rebecca Elizabeth · Elgin, TXN23787D&R LLC · Emory, TXN23792Swartz William L · Cumb Foreside, MEN2379BRegistered aircraftN2379DMoore Orville G · Hays, KSN2379NFussell Leon J · Broxton, GAN2379UAlaska Aircraft Leasing LLC · Silverdale, WAN237DTBurque Sean Michael · New Braunfels, TXN2380DKovalchik Janet N Trustee · Kernersville, NCN2380VGyrogeo Aerial Survey LLC · Bangor, MEN2381DShryock Jennifer M · King Salmon, AKN2382UMrnm LLC · Albia, IAN2383BArt-Ticulate Tees LLC · Hazard, KYN2383ELord Edward J · North Conway, NHN2383HSale Reported · Decatur, TXSale reportedN2383NEggleston Robert E · Loveland, CON23849Borzelleri Joseph Eric · Yuba City, CAN2384BAuiler Casey · San Diego, CAN2384NHirzel William J · Walbridge, OHN2385BHernandez Dominic Juan · Brighton, CON2385DHurst Gerald W · Bigfork, MTN2385UThomas Robert G · Eatonville, WAN2386DTitan Aero LLC · Wilmington, DEN2386HBerkebile Lynn B · Twin Falls, IDN2386UBratton Beryl M · Yoncalla, ORN2387VOmstead Jordan · Lamoni, IAN2388KAbercrombie Andrea D · Eatonton, GAN2388URay Charlie B · Prosser, WAN2389NFrederick Coy B · Mount Erie, ILN2389UAllworth Ruger · Wapello, IAN238BBKuzana Ron · Wasilla, AKN2390DNorman James C · Laguna Niguel, CAN2390NNewsom Kevin J · Bloomington, INN2390UKuhn Jacob H · Bloomer, WIN2390YStrong James R · Williamsville, NYN2391KWhillock Meredith J · Houston, TXN2391NMees Martin B · Eagle River, AKN2391VVanderloop Thomas J · Kaukauna, WIFirst renewal noticeN2392VRipley Craig D · Willshire, OH
Back to AD 94-05-05 R1