AD 2006-10-21
Registered aircraft · 44,908
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:2006-10-21')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21')
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:2006-10-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21') 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.
N2610RStable Aviation LLC · Eagan, MNN26110Career Track 5 LLC · Wilmington, DEN26111Career Track 5 LLC · Wilmington, DEN26112Career Track 5 LLC · Wilmington, DEN2611TW&H Services LLC · Boerne, TXN2615WSturgis Joel B · Pensacola, FLN2616WDenney David W · Fowler, CON2619DInman Steve · Billings, MTN2619WSmith Cecil · Fort Pierce, FLN261AMeridian Aircraft LLC · Wilmington, DEN261AFState Of Louisiana · Baton Rouge, LAN261BWPiper Aircraft Inc · Vero Beach, FLN261CCCook Christopher · Columbus, GAN261EPEpic Aviation Inc · Denison, TXN261ERCentral Airlines Inc · Overland Park, KSN261EZZokpodo Emmanuel K · Sacramento, CAN261FAStratus Rr LLC · New Castle, DEN261HHoward Clifford E · Auburn, WAN261JBoard Of Trustees Of Southern Illinois University · Murphysboro, ILN261KTFrisch Adam · Los Angeles, CAN261MGGeorgia Aviation Authority · Eastman, GAN261MMCockroft Scott · Kersey, CON261RSNational Aviation Partners LLC · Weatherford, TXN261SCIndia Aviation LLC · Oregon City, ORN261VFBickley Clarence R · Jefferson, GAN261WYFoss Jared K · Greenbush, MNN261XEvans Dennis · Naples, FLN2621ZWifa (Washington International Flight Academy) LLC · Gaithersburg, MDN2622HBurgess John H · Tower, MNN2622WMohamed Eman Z · Lubbock, TXN2624WWilkins James K · Owens Cross Roads, ALN2625CL&W Leasing LLC · Murfreesboro, TNN2625SSierra Aviation LLC · Plaza, NDN2625WPatton William D · Sheridan, WYN26264Edb Air Inc · Wilsonville, ORN2626SDelta Aero LLC · Sarasota, FLN2627CC And T Aviation LLC · Shreveport, LAN2627WDiamond Engineering & Service Co · Granger, INN2629WHogan James C DBA · Cameron Park, CAN262ACLavelle Jeffrey · Kenmore, WAN262AFState Of Louisiana · Baton Rouge, LAN262ALDale County Sheriffs Office · Ozark, ALN262AMChapman Kevin Joseph · Williston, NDN262ASAerodata LLC · Ann Arbor, MIN262CBCalifornia Baptist University · Riverside, CAN262CLGiga Energy Inc · Buna, TXN262ESBreshears Michael · San Antonio, TXN262GCSlepica Michael · Oregon, WIN262GGN262ggllc LLC · Reno, NVN262GRDr I T Help LLC · Cheyenne, WY
Back to AD 2006-10-21