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.
N6935FWood Roger E · Waxhaw, NCN6935XDetert Robert D · Rockdale, TXN6936AJordahl Amy L · Two Harbors, MNN6937FSale Reported · Rockton, ILSale reportedN6937SCaum David A · La Porte, INN6938GRf Aviation LLC · Owensboro, KYN6939AErtas Efe Y · Walnut Creek, CAN6939FPayne Billy Jack · Powhatan, VAN6940HBurrows Aviation LLC · Deer Park, WAN6940XWestern Aircraft Leasing LLC · Tempe, AZN6941EMohagen Henry C · Reva, SDN6941FMorgan Stuart G · Spring Valley, CAN6941SBrowning Stephen D · Bear, DEN6942AHaskell Thomas L · Summerville, SCN6942EOakland Dennis E · Glennallen, AKN6942HW Lance Orr · Gig Harbor, WAN6943ELasky Robert C · New Richmond, WIN6943GBoydston Tony C · El Paso, TXN6943SBoniek Martin J · Nederland, CON6944SVfr Aviation LLC · Clayton, NYN6945EFiltration & Separation Technologies Inc · Glen Ellyn, ILN6945XA Team Motors LLC DBA · Henderson, NVN6946F46fox Aviation LLC · Bedminster, NJN6946SImage Aviation Services LLC · Wilmington, DEN6947EFirestone Bradley W · Colville, WAN6947GLin-Aero LLC · Conway, ARN6948ASelf David J · Wagener, SCN6948ESchrader Leif · Myrtle Point, ORN6948FLee Ethan · Millsap, TXN6948GJbar Ranch LLC · Downey, IDN6948SZaremba Michael W · Custer, WIN6948XWalburg Frank L · Zanesville, OHN6949EFoster David B · Athens, TNN6949FConaway Byron Richard · Savannah, TNN6949GTillstrom Gary A · Memphis, TNN6950AGallagher David R · Auburndale, FLN6950EMahler Jacson B · Reno, NVN6950FRgv Flight Academy LLC · Bayview, TXN6951GHernandez Alfonso · Garland, TXN6952ABig Sky Adventures LLC · Nicholasville, KYN6952EBeauchamp James W · Butte, MTN6952FSkalsky Nathan · Tigard, ORN6952SMyers Karen J · Bemidji, MNN6953GVidal Miguel · Novi, MIN6954ALindroth Richard J · Eleanor, WVN6954EBaylis Thomas B · Hattiesburg, MSN6954FRegistration Pending · Sumner, WARegistration pendingN6954SPierson Jared · Coeur D Alene, IDN6954XSebestik William C · Walker, MNN6955AFortman James · Vancouver, WA
Back to AD 94-05-05 R1